APPS.XTR_REPLICATE_BANK_BALANCES dependencies on CE_BANK_ACCT_USES_ALL

Line 222: l_bank_account_id CE_BANK_ACCT_USES_ALL.BANK_ACCOUNT_ID%TYPE;

218: x_msg_count OUT NOCOPY NUMBER,
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:

Line 228: select bank_account_id from ce_bank_acct_uses_all

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
229: where bank_account_id = (select bank_account_id from
230: ce_bank_acct_balances
231: where bank_acct_balance_id =
232: p_ce_bank_account_balance_id)

Line 238: from ce_bank_acct_uses_all acct

234:
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'

Line 346: l_invest_limit_code ce_bank_acct_uses_all.investment_limit_code%TYPE;

342: l_prv_prv_day_count_type XTR_BANK_BALANCES.day_count_type%TYPE;
343: l_oldest_date XTR_BANK_BALANCES.balance_date%TYPE;
344:
345: l_first_trans_flag VARCHAR2(1);
346: l_invest_limit_code ce_bank_acct_uses_all.investment_limit_code%TYPE;
347: l_fund_limit_code ce_bank_acct_uses_all.funding_limit_code%TYPE;
348:
349:
350: l_no_days NUMBER;

Line 347: l_fund_limit_code ce_bank_acct_uses_all.funding_limit_code%TYPE;

343: l_oldest_date XTR_BANK_BALANCES.balance_date%TYPE;
344:
345: l_first_trans_flag VARCHAR2(1);
346: l_invest_limit_code ce_bank_acct_uses_all.investment_limit_code%TYPE;
347: l_fund_limit_code ce_bank_acct_uses_all.funding_limit_code%TYPE;
348:
349:
350: l_no_days NUMBER;
351:

Line 393: from ce_bank_acct_uses_all

389:
390: -- Getting the limit code
391: CURSOR GET_LIM_CODE is
392: select investment_limit_code, funding_limit_code
393: from ce_bank_acct_uses_all
394: where bank_account_id in ( select bank_account_id from
395: ce_bank_acct_balances
396: where bank_acct_balance_id = p_balance_rec.ce_bank_account_balance_id
397: );