APPS.XTR_REPLICATE_BANK_BALANCES dependencies on CE_CASHPOOLS

Line 223: l_cashpool_id CE_CASHPOOLS.CASHPOOL_ID%TYPE;

219: x_msg_data OUT NOCOPY VARCHAR2) IS
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

Line 245: , ce_cashpools pool

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' );
249: