APPS.CE_ZBA_DEAL_GENERATION dependencies on CE_BANK_ACCOUNTS

Line 12: FROM ce_bank_accounts cba

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

Line 34: FROM ce_bank_accounts cba,

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

Line 584: from ce_bank_accounts ba, ce_bank_acct_uses_all bau

580: cep_standard.debug('>>validate existing of unreconciled sweep lines');
581: else --Validate the bank account is an authorized treasury account
582: if fnd_profile.value('CE_BANK_ACCOUNT_TRANSFERS') = 'XTR' then
583: select count(1) into l_count
584: from ce_bank_accounts ba, ce_bank_acct_uses_all bau
585: where ba.bank_account_id = CE_ZBA_DEAL_GENERATION.csh_bank_account_id
586: and bau.bank_account_id = ba.bank_account_id
587: and ba.xtr_use_allowed_flag = 'Y'
588: and bau.authorized_flag = 'Y';