eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_INTEREST_CALC dependencies on CE_INTEREST_BAL_RANGES

Line 124: , CE_INTEREST_BAL_RANGES IBR

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
126: cIS.INTEREST_SCHEDULE_ID = IBR.INTEREST_SCHEDULE_ID
127: and cIS.INTEREST_SCHEDULE_ID = p_interest_schedule_id --10002
128: --AND cIS.INTEREST_SCHEDULE_ID = ba.INTEREST_SCHEDULE_ID

Line 166: , CE_INTEREST_BAL_RANGES IBR

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
168: cIS.INTEREST_SCHEDULE_ID = IBR.INTEREST_SCHEDULE_ID
169: and cIS.INTEREST_SCHEDULE_ID = p_interest_schedule_id --10002
170: --AND cIS.INTEREST_SCHEDULE_ID = ba.INTEREST_SCHEDULE_ID

Line 212: , CE_INTEREST_BAL_RANGES IBR

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
214: WHERE
215: CIS.INTEREST_SCHEDULE_ID = IBR.INTEREST_SCHEDULE_ID
216: AND IBR.BALANCE_RANGE_ID = IR.BALANCE_RANGE_ID

Line 269: CE_INTEREST_BAL_RANGES IBR

265: select ir.interest_rate,
266: tmp.from_date,
267: tmp.INTEREST_CALC_DETAIL_ID
268: from
269: CE_INTEREST_BAL_RANGES IBR
270: , ce_interest_rates ir
271: , CE_INT_CALC_DETAILS_GT tmp
272: where
273: ibr.balance_range_id = ir.balance_range_id

Line 282: CE_INTEREST_BAL_RANGES IBR

278: and tmp.interest_schedule_id = ibr.interest_schedule_id
279: and ir.effective_date <= tmp.from_date
280: and ir.effective_date = (select max(ir.effective_date)
281: from
282: CE_INTEREST_BAL_RANGES IBR
283: , ce_interest_rates ir
284: , CE_INT_CALC_DETAILS_GT tmp2
285: where
286: ibr.balance_range_id = ir.balance_range_id

Line 305: from ce_interest_bal_ranges ibr

301: select
302: nvl(FROM_BALANCE_AMOUNT, l_amount),
303: nvl(TO_BALANCE_AMOUNT, 0),
304: ir.interest_rate
305: from ce_interest_bal_ranges ibr
306: , ce_interest_rates ir
307: where ibr.INTEREST_SCHEDULE_ID = p_interest_schedule_id
308: and ibr.TO_BALANCE_AMOUNT >= l_amount
309: and ibr.TO_BALANCE_AMOUNT <= 0

Line 357: from ce_interest_bal_ranges ibr

353: and ir2.balance_range_id = ir.BALANCE_RANGE_ID
354: )
355: ) INTEREST_RATES*/
356: ir.interest_rate
357: from ce_interest_bal_ranges ibr
358: , ce_interest_rates ir
359: where ibr.INTEREST_SCHEDULE_ID = p_interest_schedule_id
360: and ibr.FROM_BALANCE_AMOUNT <= l_amount
361: and ibr.FROM_BALANCE_AMOUNT >= 0

Line 417: , CE_INTEREST_BAL_RANGES IBR

413: and ir2.balance_range_id = ir.BALANCE_RANGE_ID
414: )
415: ) INTEREST_RATES
416: from CE_INT_CALC_DETAILS_GT tmp
417: , CE_INTEREST_BAL_RANGES IBR
418: -- , CE_INTEREST_RATES IR
419: where tmp.INTEREST_SCHEDULE_ID = p_interest_schedule_id
420: and tmp.INTEREST_SCHEDULE_ID = IBR.INTEREST_SCHEDULE_ID
421: -- AND IBR.BALANCE_RANGE_ID = IR.BALANCE_RANGE_ID

Line 460: --, CE_INTEREST_BAL_RANGES IBR

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
462: --cIS.INTEREST_SCHEDULE_ID = IBR.INTEREST_SCHEDULE_ID
463: cIS.INTEREST_SCHEDULE_ID = p_interest_schedule_id --10002
464: --AND cIS.INTEREST_SCHEDULE_ID = ba.INTEREST_SCHEDULE_ID

Line 512: --, CE_INTEREST_BAL_RANGES IBR

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
514: --cIS.INTEREST_SCHEDULE_ID = IBR.INTEREST_SCHEDULE_ID
515: cIS.INTEREST_SCHEDULE_ID = p_interest_schedule_id --10002
516: --AND cIS.INTEREST_SCHEDULE_ID = ba.INTEREST_SCHEDULE_ID

Line 569: , CE_INTEREST_BAL_RANGES IBR

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
571: , CE_INT_CALC_DETAILS_GT tmpx
572: WHERE
573: cIS.INTEREST_SCHEDULE_ID = IBR.INTEREST_SCHEDULE_ID

Line 721: , CE_INTEREST_BAL_RANGES IBR

717: into p_interest_rate
718: from
719: CE_BANK_ACCOUNTS BA
720: , CE_INTEREST_SCHEDULES cIS
721: , CE_INTEREST_BAL_RANGES IBR
722: , CE_INTEREST_RATES IR
723: WHERE
724: BA.BANK_ACCOUNT_ID = p_bank_account_id --10001
725: AND cIS.INTEREST_SCHEDULE_ID = BA.INTEREST_SCHEDULE_ID

Line 743: , CE_INTEREST_BAL_RANGES IBR

739: into p_interest_rate
740: from
741: CE_BANK_ACCOUNTS BA
742: , CE_INTEREST_SCHEDULES cIS
743: , CE_INTEREST_BAL_RANGES IBR
744: , CE_INTEREST_RATES IR
745: WHERE
746: BA.BANK_ACCOUNT_ID = p_bank_account_id --10001
747: AND cIS.INTEREST_SCHEDULE_ID = BA.INTEREST_SCHEDULE_ID

Line 1830: FROM ce_interest_bal_ranges

1826: where bank_account_id = p_bank_account_id;
1827:
1828: SELECT MIN(FROM_BALANCE_AMOUNT)
1829: INTO x_add_min_pre_amt
1830: FROM ce_interest_bal_ranges
1831: WHERE INTEREST_SCHEDULE_ID = p_interest_schedule_id
1832: AND FROM_BALANCE_AMOUNT > 0;
1833:
1834: IF l_DEBUG in ('Y', 'C') THEN