APPS.CE_ZBA_DEAL_GENERATION dependencies on CE_BANK_ACCOUNTS

Line 11: FROM ce_bank_accounts cba

7: p_bank_branch_id NUMBER,
8: p_bank_account_id NUMBER
9: ) IS
10: SELECT cba.bank_account_id
11: FROM ce_bank_accounts cba
12: WHERE cba.bank_branch_id = p_bank_branch_id
13: AND cba.bank_account_id = NVL(p_bank_account_id, cba.bank_account_id)
14: ORDER BY cba.bank_account_name;
15:

Line 35: FROM ce_bank_accounts cba,

31: cba.check_digits,
32: csh.rowid,
33: NVL(csh.statement_complete_flag,'N'),
34: csh.org_id
35: FROM ce_bank_accounts cba,
36: ce_statement_headers csh
37: WHERE cba.bank_account_id = NVL(p_bank_account_id,cba.bank_account_id)
38: AND cba.bank_account_id = csh.bank_account_id
39: AND csh.statement_number BETWEEN

Line 580: FROM ce_bank_accounts ba, ce_bank_acct_uses_all bau

576: IF fnd_profile.value('CE_BANK_ACCOUNT_TRANSFERS') = 'XTR'
577: THEN
578: SELECT count(1)
579: INTO l_count
580: FROM ce_bank_accounts ba, ce_bank_acct_uses_all bau
581: WHERE ba.bank_account_id = CE_ZBA_DEAL_GENERATION.csh_bank_account_id
582: AND bau.bank_account_id = ba.bank_account_id
583: AND ba.xtr_use_allowed_flag = 'Y'
584: AND bau.authorized_flag = 'Y';

Line 693: FROM ce_bank_accounts cba,

689: WHERE statement_line_id = CE_ZBA_DEAL_GENERATION.csl_statement_line_id;
690:
691: SELECT cps. account_id
692: INTO l_dst_bank_acct_id
693: FROM ce_bank_accounts cba,
694: ce_cashpools cp,
695: CE_CASHPOOL_SUB_ACCTS cps
696: WHERE cba.bank_account_id = cp.conc_account_id
697: AND cp.cashpool_id = cps.cashpool_id

Line 700: FROM ce_bank_accounts

696: WHERE cba.bank_account_id = cp.conc_account_id
697: AND cp.cashpool_id = cps.cashpool_id
698: AND cps.type in ('ACCT','CONC','INV','FUND') /* bug 14140123 */
699: AND cps.account_id IN (SELECT bank_account_id
700: FROM ce_bank_accounts
701: WHERE bank_account_num = l_bank_acct_text);
702:
703: EXCEPTION
704: WHEN OTHERS