APPS.CE_INTEREST_CALC dependencies on CE_BANK_ACCT_BALANCES

Line 121: CE_BANK_ACCT_BALANCES BAB

117: ) INTEREST_RATES
118: , 'Y' FIRST_ROW
119: , rownum
120: from
121: CE_BANK_ACCT_BALANCES BAB
122: --, CE_BANK_ACCOUNTS BA
123: , CE_INTEREST_SCHEDULES cIS
124: , CE_INTEREST_BAL_RANGES IBR
125: WHERE

Line 141: from CE_BANK_ACCT_BALANCES BAB2

137: , BAB.VALUE_DATED_BALANCE
138: , IBR.BALANCE_RANGE_ID
139: , rownum
140: having max(BAB.BALANCE_DATE) = (select max(bab2.balance_date)
141: from CE_BANK_ACCT_BALANCES BAB2
142: where BAb2.BANK_ACCOUNT_ID = BAB.BANK_ACCOUNT_ID
143: and BAB2.BALANCE_DATE <= p_from_date) --'01-May-2004')
144: UNION ALL
145: select

Line 163: CE_BANK_ACCT_BALANCES BAB

159: ) INTEREST_RATES
160: , 'N' FIRST_ROW
161: , rownum
162: from
163: CE_BANK_ACCT_BALANCES BAB
164: --, CE_BANK_ACCOUNTS BA
165: , CE_INTEREST_SCHEDULES cIS
166: , CE_INTEREST_BAL_RANGES IBR
167: WHERE

Line 209: --CE_BANK_ACCT_BALANCES BAB

205: ) VALUE_DATED_BALANCE */
206: , IR.BALANCE_RANGE_ID
207: , IR.INTEREST_RATE
208: from
209: --CE_BANK_ACCT_BALANCES BAB
210: CE_INT_CALC_DETAILS_GT tmp2 --, CE_BANK_ACCOUNTS BA
211: , CE_INTEREST_SCHEDULES CIS
212: , CE_INTEREST_BAL_RANGES IBR
213: , CE_INTEREST_RATES IR

Line 457: CE_BANK_ACCT_BALANCES BAB

453: ) INTEREST_RATES*/
454: , 'Y' FIRST_ROW
455: , rownum
456: from
457: CE_BANK_ACCT_BALANCES BAB
458: --, CE_BANK_ACCOUNTS BA
459: , CE_INTEREST_SCHEDULES cIS
460: --, CE_INTEREST_BAL_RANGES IBR
461: WHERE

Line 486: from CE_BANK_ACCT_BALANCES BAB2

482: , BAB.VALUE_DATED_BALANCE
483: --, IBR.BALANCE_RANGE_ID
484: , rownum
485: having max(BAB.BALANCE_DATE) = (select max(bab2.balance_date)
486: from CE_BANK_ACCT_BALANCES BAB2
487: where BAb2.BANK_ACCOUNT_ID = BAB.BANK_ACCOUNT_ID
488: and BAB2.BALANCE_DATE <= p_from_date) --'01-May-2004')
489: UNION ALL
490: select

Line 509: CE_BANK_ACCT_BALANCES BAB

505: ) INTEREST_RATES*/
506: , 'N' FIRST_ROW
507: , rownum
508: from
509: CE_BANK_ACCT_BALANCES BAB
510: --, CE_BANK_ACCOUNTS BA
511: , CE_INTEREST_SCHEDULES cIS
512: --, CE_INTEREST_BAL_RANGES IBR
513: WHERE

Line 566: -- CE_BANK_ACCT_BALANCES BAB

562: ) VALUE_DATED_BALANCE*/
563: , IR.BALANCE_RANGE_ID
564: , IR.INTEREST_RATE
565: from
566: -- CE_BANK_ACCT_BALANCES BAB
567: --, CE_BANK_ACCOUNTS BA
568: CE_INTEREST_SCHEDULES cIS
569: , CE_INTEREST_BAL_RANGES IBR
570: , CE_INTEREST_RATES IR

Line 1825: from ce_bank_acct_balances

1821:
1822: -- bug 5393669/5479708
1823: select min(BALANCE_DATE) , max(BALANCE_DATE)
1824: INTO x_min_balance_date , x_max_balance_date
1825: from ce_bank_acct_balances
1826: where bank_account_id = p_bank_account_id;
1827:
1828: SELECT MIN(FROM_BALANCE_AMOUNT)
1829: INTO x_add_min_pre_amt