Bank Statement Import and rejected Query - Oracle ERP Cloud

Imported Query :

select hp.party_name "Bank Name",

cba.bank_account_name,

cba.bank_account_num,

csh.statement_number,

csl.trx_type,

csl.flow_indicator,

csl.amount

from ce_statement_headers csh,

ce_statement_lines csl,

ce_bank_accounts cba,

hz_parties hp

where csl.statement_header_id = csh.statement_header_id

and cba.bank_account_id = csh.bank_account_id

and hp.party_id = cba.bank_id

and hp.party_name = :pBankName

and (TRUNC(csh.creation_date) = TRUNC(sysdate)

or csh.statement_number = :statement_number)

Error Query:

select hp.party_name,

cba.bank_account_name,

cshi.bank_account_num,

cshi.statement_number,

cshi.statement_date,

csie.error_msg,

csie.creation_date

from ce_statement_headers_int cshi,

ce_stmt_import_errors csie,

ce_bank_accounts cba,

hz_parties hp

where csie.statement_header_int_id = cshi.statement_header_int_id

and cba.bank_account_num = cshi.bank_account_num

and hp.party_id = cba.bank_id

and hp.party_name = :pBankName

and TRUNC(csie.creation_date) = TRUNC(SYSDATE)

Hope this Helps!