APPS.CE_BANK_AND_ACCOUNT_UTIL dependencies on CE_BANK_ACCT_USES_ALL

Line 78: FROM ce_bank_acct_uses_all

74: /* select bank_account_id's */
75: SELECT DISTINCT bank_account_id
76: BULK COLLECT
77: INTO bank_acct_idtbl
78: FROM ce_bank_acct_uses_all
79: WHERE org_id = p_org_id;
80:
81: --bug 3855002
82: IF (l_bank_acct_list IS NULL) THEN

Line 166: ce_bank_acct_uses_all ce_bau

162: BULK COLLECT
163: INTO x_bank_acct_ids
164: FROM ( SELECT ce_ba.bank_account_id
165: FROM ce_bank_accounts ce_ba,
166: ce_bank_acct_uses_all ce_bau
167: WHERE ce_ba.bank_account_id = ce_bau.bank_account_id
168: AND NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
169: AND (ce_ba.currency_code = p_currency
170: or ce_ba.MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527

Line 184: ce_bank_acct_uses_all ce_bau

180: SELECT ce_ba.bank_account_id
181: BULK COLLECT
182: INTO x_bank_acct_ids
183: FROM ce_bank_accounts ce_ba,
184: ce_bank_acct_uses_all ce_bau
185: WHERE ce_ba.bank_account_id = ce_bau.bank_account_id
186: AND NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
187: AND (ce_ba.currency_code = p_currency
188: or ce_ba.MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527