APPS.CE_BANK_AND_ACCOUNT_UTIL dependencies on CE_BANK_ACCT_USES_ALL

Line 136: FROM ce_bank_acct_uses_all

132: /* select bank_account_id's */
133: SELECT DISTINCT bank_account_id
134: BULK COLLECT
135: INTO bank_acct_idtbl
136: FROM ce_bank_acct_uses_all
137: WHERE org_id = p_org_id;
138:
139: --bug 3855002
140: IF (l_bank_acct_list IS NULL) THEN

Line 224: ce_bank_acct_uses_all ce_bau

220: BULK COLLECT
221: INTO x_bank_acct_ids
222: FROM ( SELECT ce_ba.bank_account_id
223: FROM ce_bank_accounts ce_ba,
224: ce_bank_acct_uses_all ce_bau
225: WHERE ce_ba.bank_account_id = ce_bau.bank_account_id
226: AND NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
227: AND (ce_ba.currency_code = p_currency
228: or ce_ba.MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527

Line 242: ce_bank_acct_uses_all ce_bau

238: SELECT ce_ba.bank_account_id
239: BULK COLLECT
240: INTO x_bank_acct_ids
241: FROM ce_bank_accounts ce_ba,
242: ce_bank_acct_uses_all ce_bau
243: WHERE ce_ba.bank_account_id = ce_bau.bank_account_id
244: AND NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
245: AND (ce_ba.currency_code = p_currency
246: or ce_ba.MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527

Line 295: ce_bank_acct_uses_all ce_bau

291: SELECT Count(BA.bank_account_id)
292: INTO l_count
293: FROM ( SELECT ce_ba.bank_account_id
294: FROM ce_bank_accounts ce_ba,
295: ce_bank_acct_uses_all ce_bau
296: WHERE ce_ba.bank_account_id = ce_bau.bank_account_id
297: AND ce_ba.bank_account_id = p_internal_bank_account_id
298: AND NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
299: AND (ce_ba.currency_code = p_currency

Line 316: ce_bank_acct_uses_all ce_bau

312: ELSIF p_org_type in ('OPERATING_UNIT', 'BUSINESS_GROUP') THEN
313: SELECT Count(ce_ba.bank_account_id)
314: INTO l_count
315: FROM ce_bank_accounts ce_ba,
316: ce_bank_acct_uses_all ce_bau
317: WHERE ce_ba.bank_account_id = ce_bau.bank_account_id
318: AND ce_ba.bank_account_id = p_internal_bank_account_id
319: AND NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
320: AND (ce_ba.currency_code = p_currency

Line 339: ce_bank_acct_uses_all ce_bau

335: BULK COLLECT
336: INTO l_bank_acct_ids
337: FROM ( SELECT ce_ba.bank_account_id
338: FROM ce_bank_accounts ce_ba,
339: ce_bank_acct_uses_all ce_bau
340: WHERE ce_ba.bank_account_id = ce_bau.bank_account_id
341: AND NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
342: AND (ce_ba.currency_code = p_currency
343: or ce_ba.MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527

Line 358: ce_bank_acct_uses_all ce_bau

354: SELECT ce_ba.bank_account_id
355: BULK COLLECT
356: INTO l_bank_acct_ids
357: FROM ce_bank_accounts ce_ba,
358: ce_bank_acct_uses_all ce_bau
359: WHERE ce_ba.bank_account_id = ce_bau.bank_account_id
360: AND NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
361: AND (ce_ba.currency_code = p_currency
362: or ce_ba.MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527