APPS.XTR_ACCOUNT_BAL_MAINT_P dependencies on CE_BANK_ACCT_BALANCES

Line 553: FROM ce_bank_acct_balances --4696629

549: --
550: -- R12 modified the Cursor. Removed the reference to AP_BANK_ACCOUNT_ID and Dummy_bank_account_id
551: cursor SETOFF_CAL_DATE IS
552: SELECT distinct balance_date
553: FROM ce_bank_acct_balances --4696629
554: WHERE balance_date >= p_calc_date
555: AND bank_account_id IN
556: (SELECT account_id acct_id
557: FROM ce_cashpool_sub_accts

Line 598: FROM CE_BANK_ACCT_BALANCES a --bug 4696629

594: cursor SETOFF_THIS_DETAILS is
595: SELECT nvl(sum(a.LEDGER_BALANCE),0),
596: nvl(sum(a.VALUE_DATED_BALANCE-a.LEDGER_BALANCE),0),
597: nvl(sum(a.AVAILABLE_BALANCE),0)
598: FROM CE_BANK_ACCT_BALANCES a --bug 4696629
599: WHERE a.bank_account_id IN
600: (SELECT account_id acct_id
601: FROM ce_cashpool_sub_accts
602: WHERE cashpool_id = p_cashpool_id

Line 618: FROM CE_BANK_ACCT_BALANCES b

614: AND type = 'POOL'
615: AND fund_conc_account_id is not null)
616: AND a.BALANCE_DATE = (
617: SELECT max(b.BALANCE_DATE)
618: FROM CE_BANK_ACCT_BALANCES b
619: WHERE b.BANK_ACCOUNT_ID = a.BANK_ACCOUNT_ID
620: AND b.BALANCE_DATE <= l_calc_date);
621:
622: -- Added for Interest Override