APPS.CE_PURGE_TRX_CODES_XML dependencies on CE_BANK_ACCOUNTS

Line 51: FROM ce_bank_accounts CBA

47: --bank account
48: IF p_bank_acct_id IS NOT NULL
49: THEN
50: SELECT CBA.bank_account_num INTO g_account_num
51: FROM ce_bank_accounts CBA
52: WHERE CBA.bank_account_id = p_bank_acct_id;
53: ELSE
54: g_account_num := NULL;
55: END IF;

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