APPS.CE_INTEREST_CALC dependencies on CE_BAL_UTIL

Line 441: , ce_bal_util.get_pool_balance(p_cashpool_id, p_from_date) VALUE_DATED_BALANCE --BAB.VALUE_DATED_BALANCE

437: ) IS
438: select
439: BAB.BANK_ACCOUNT_ID
440: , max(BAB.BALANCE_DATE) BALANCE_DATE_FROM
441: , ce_bal_util.get_pool_balance(p_cashpool_id, p_from_date) VALUE_DATED_BALANCE --BAB.VALUE_DATED_BALANCE
442: , NULL BALANCE_RANGE_ID --IBR.BALANCE_RANGE_ID
443: , NULL INTEREST_RATES
444: /*, (select distinct ir.interest_rate
445: from CE_INTEREST_RATES IR

Line 493: , ce_bal_util.get_pool_balance(p_cashpool_id, BAB.BALANCE_DATE) --VALUE_DATED_BALANCE --BAB.VALUE_DATED_BALANCE

489: UNION ALL
490: select
491: BAB.BANK_ACCOUNT_ID
492: , BAB.BALANCE_DATE --BALANCE_DATE_FROM
493: , ce_bal_util.get_pool_balance(p_cashpool_id, BAB.BALANCE_DATE) --VALUE_DATED_BALANCE --BAB.VALUE_DATED_BALANCE
494: , NULL BALANCE_RANGE_ID --IBR.BALANCE_RANGE_ID
495: , NULL INTEREST_RATES
496: /* , (select distinct ir.interest_rate
497: from CE_INTEREST_RATES IR

Line 2441: -- ce_bal_util.get_pool_balance(p_cashpool_id, p_from_date) will get total

2437: p_cashpool_id
2438: );
2439:
2440: -- do not call cashpool_accts_cur
2441: -- ce_bal_util.get_pool_balance(p_cashpool_id, p_from_date) will get total
2442: -- balances for cashpool accounts (includes: ('CONC', 'ACCT', 'NEST'))
2443: --OPEN cashpool_accts_cur (p_cashpool_id );
2444: --LOOP
2445: --FETCH cashpool_accts_cur INTO x_bank_account_id;