APPS.CE_PURGE_TRX_CODES_XML dependencies on CE_TRANSACTION_CODES

Line 124: FROM CE_TRANSACTION_CODES CTC, CE_BANK_ACCOUNTS_V CBA

120: CTC.trx_code,
121: CTC.bank_account_id,
122: CTC.description,
123: CTC.trx_type
124: FROM CE_TRANSACTION_CODES CTC, CE_BANK_ACCOUNTS_V CBA
125: WHERE -- fetch codes as per input parameters
126: DECODE(p_process_option, 'COPIED', CTC.request_id, 'ALL', 1) =
127: DECODE(p_process_option, 'COPIED', NVL(p_request_id, CTC.request_id), 'ALL', 1)
128: AND CTC.bank_account_id = CBA.bank_account_id

Line 167: DELETE ce_transaction_codes CTC

163: WHERE ASL.trx_code_id = CTC.transaction_code_id
164: );
165:
166: debug_log('Deleting transaction codes');
167: DELETE ce_transaction_codes CTC
168: WHERE EXISTS(
169: SELECT 1
170: FROM ce_trx_codes_util_gt GT
171: WHERE GT.trx_code_id = CTC.transaction_code_id);