DBA Data[Home] [Help]

APPS.XTR_REPLICATE_BANK_BALANCES dependencies on CE_BANK_ACCT_BALANCES

Line 211: p_ledger_balance IN CE_BANK_ACCT_BALANCES.ledger_balance%TYPE,

207: ( p_ce_bank_account_balance_id IN XTR_BANK_BALANCES.ce_bank_account_balance_id%TYPE,
208: p_company_code IN XTR_BANK_BALANCES.company_code%TYPE,
209: p_account_number IN XTR_BANK_BALANCES.account_number%TYPE,
210: p_balance_date IN XTR_BANK_BALANCES.balance_date%TYPE,
211: p_ledger_balance IN CE_BANK_ACCT_BALANCES.ledger_balance%TYPE,
212: p_available_balance IN CE_BANK_ACCT_BALANCES.available_balance%TYPE,
213: p_interest_calculated_balance IN CE_BANK_ACCT_BALANCES.value_dated_balance%TYPE,
214: p_one_day_float IN XTR_BANK_BALANCES.one_day_float%TYPE,
215: p_two_day_float IN XTR_BANK_BALANCES.two_day_float%TYPE,

Line 212: p_available_balance IN CE_BANK_ACCT_BALANCES.available_balance%TYPE,

208: p_company_code IN XTR_BANK_BALANCES.company_code%TYPE,
209: p_account_number IN XTR_BANK_BALANCES.account_number%TYPE,
210: p_balance_date IN XTR_BANK_BALANCES.balance_date%TYPE,
211: p_ledger_balance IN CE_BANK_ACCT_BALANCES.ledger_balance%TYPE,
212: p_available_balance IN CE_BANK_ACCT_BALANCES.available_balance%TYPE,
213: p_interest_calculated_balance IN CE_BANK_ACCT_BALANCES.value_dated_balance%TYPE,
214: p_one_day_float IN XTR_BANK_BALANCES.one_day_float%TYPE,
215: p_two_day_float IN XTR_BANK_BALANCES.two_day_float%TYPE,
216: p_action_flag IN varchar2,

Line 213: p_interest_calculated_balance IN CE_BANK_ACCT_BALANCES.value_dated_balance%TYPE,

209: p_account_number IN XTR_BANK_BALANCES.account_number%TYPE,
210: p_balance_date IN XTR_BANK_BALANCES.balance_date%TYPE,
211: p_ledger_balance IN CE_BANK_ACCT_BALANCES.ledger_balance%TYPE,
212: p_available_balance IN CE_BANK_ACCT_BALANCES.available_balance%TYPE,
213: p_interest_calculated_balance IN CE_BANK_ACCT_BALANCES.value_dated_balance%TYPE,
214: p_one_day_float IN XTR_BANK_BALANCES.one_day_float%TYPE,
215: p_two_day_float IN XTR_BANK_BALANCES.two_day_float%TYPE,
216: p_action_flag IN varchar2,
217: x_return_status OUT NOCOPY VARCHAR2,

Line 230: ce_bank_acct_balances

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)
233: and xtr_use_enable_flag = 'Y';
234:

Line 395: ce_bank_acct_balances

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: );
398:
399: