APPS.XTR_REPLICATE_BANK_BALANCES dependencies on CE_CASHPOOL_SUB_ACCTS

Line 224: l_conc_account_id CE_CASHPOOL_SUB_ACCTS.ACCOUNT_ID%TYPE;

220:
221: l_xtr_bank_balances_rec XTR_BANK_BALANCES%ROWTYPE;
222: l_bank_account_id CE_BANK_ACCT_USES_ALL.BANK_ACCOUNT_ID%TYPE;
223: l_cashpool_id CE_CASHPOOLS.CASHPOOL_ID%TYPE;
224: l_conc_account_id CE_CASHPOOL_SUB_ACCTS.ACCOUNT_ID%TYPE;
225:
226:
227: cursor c_bank_account_id is
228: select bank_account_id from ce_bank_acct_uses_all

Line 239: , ce_Cashpool_sub_accts sub

235:
236: cursor c_conc_cashpool_id is
237: select sub.cashpool_id, sub.account_id
238: from ce_bank_acct_uses_all acct
239: , ce_Cashpool_sub_accts sub
240: where acct.bank_account_id = sub.account_id
241: and acct.xtr_use_enable_flag = 'Y'
242: and sub.type = 'CONC'
243: and cashpool_id = (select subacct.cashpool_id

Line 244: from ce_cashpool_sub_accts subacct

240: where acct.bank_account_id = sub.account_id
241: and acct.xtr_use_enable_flag = 'Y'
242: and sub.type = 'CONC'
243: and cashpool_id = (select subacct.cashpool_id
244: from ce_cashpool_sub_accts subacct
245: , ce_cashpools pool
246: where account_id = l_bank_account_id
247: and subacct.cashpool_id = pool.cashpool_id
248: and pool.type = 'NOTIONAL' );