DBA Data[Home] [Help]

APPS.CE_PURGE_TRX_CODES_XML dependencies on CE_STATEMENT_HEADERS

Line 137: FROM ce_statement_lines CSL, ce_statement_headers CSH

133: OR CBA.bank_account_type = NVL(p_acct_type, CBA.bank_account_type))
134: -- code should not be used in bank statement lines
135: AND NOT EXISTS (
136: SELECT NULL
137: FROM ce_statement_lines CSL, ce_statement_headers CSH
138: WHERE CSL.statement_header_id = CSH.statement_header_id
139: AND CSH.bank_account_id = CTC.bank_account_id
140: AND CSL.trx_type = CTC.trx_type
141: AND CSL.trx_code = CTC.trx_code)