APPS.CE_COPY_TRX_CODES_XML dependencies on CE_BANK_ACCOUNTS

Line 33: FROM ce_bank_accounts CBA

29: IF p_source_acct_id IS NOT NULL
30: THEN
31: SELECT SUBSTR(CBA.bank_account_name,0,50), CBA.bank_account_num
32: INTO g_source_account_name, g_source_account_num
33: FROM ce_bank_accounts CBA
34: WHERE CBA.bank_account_id = p_source_acct_id;
35: ELSE
36: g_source_account_name := NULL;
37: g_source_account_num := NULL;

Line 66: FROM ce_bank_accounts CBA

62: --destination account
63: IF p_dest_acct_id IS NOT NULL
64: THEN
65: SELECT CBA.bank_account_num INTO g_dest_account_num
66: FROM ce_bank_accounts CBA
67: WHERE CBA.bank_account_id = p_dest_acct_id;
68: ELSE
69: g_dest_account_num := NULL;
70: END IF;

Line 262: FROM ce_bank_accounts_v CBA

258:
259: --cursor to fetch destination accounts
260: CURSOR get_dest_accounts IS
261: SELECT CBA.bank_account_id
262: FROM ce_bank_accounts_v CBA
263: WHERE CBA.bank_account_id = NVL(p_dest_acct_id, CBA.bank_account_id)
264: AND ((CBA.bank_account_type IS NULL AND p_dest_acct_type IS NULL)
265: OR CBA.bank_account_type = NVL(p_dest_acct_type, CBA.bank_account_type))
266: AND CBA.bank_branch_id = NVL(p_dest_branch_id, CBA.bank_branch_id)