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_RATES

Line 109: from CE_INTEREST_RATES IR

105: , max(BAB.BALANCE_DATE) BALANCE_DATE_FROM
106: , BAB.VALUE_DATED_BALANCE
107: , IBR.BALANCE_RANGE_ID
108: , (select distinct ir.interest_rate
109: from CE_INTEREST_RATES IR
110: where ir.balance_range_id = IBR.BALANCE_RANGE_ID
111: and ir.effective_date =
112: (select max(ir2.effective_date)
113: from CE_INTEREST_RATES IR2

Line 113: from CE_INTEREST_RATES IR2

109: from CE_INTEREST_RATES IR
110: where ir.balance_range_id = IBR.BALANCE_RANGE_ID
111: and ir.effective_date =
112: (select max(ir2.effective_date)
113: from CE_INTEREST_RATES IR2
114: where ir2.effective_date <= p_from_date --'31-DEC-2003' --max(BAB.BALANCE_DATE)
115: and ir2.balance_range_id = ir.BALANCE_RANGE_ID
116: )
117: ) INTEREST_RATES

Line 151: from CE_INTEREST_RATES IR

147: , BAB.BALANCE_DATE BALANCE_DATE_FROM
148: , BAB.VALUE_DATED_BALANCE
149: , IBR.BALANCE_RANGE_ID
150: , (select distinct ir.interest_rate
151: from CE_INTEREST_RATES IR
152: where ir.balance_range_id = IBR.BALANCE_RANGE_ID
153: and ir.effective_date =
154: (select max(ir2.effective_date)
155: from CE_INTEREST_RATES IR2

Line 155: from CE_INTEREST_RATES IR2

151: from CE_INTEREST_RATES IR
152: where ir.balance_range_id = IBR.BALANCE_RANGE_ID
153: and ir.effective_date =
154: (select max(ir2.effective_date)
155: from CE_INTEREST_RATES IR2
156: where ir2.effective_date <= BAB.BALANCE_DATE
157: and ir2.balance_range_id = ir.BALANCE_RANGE_ID
158: )
159: ) INTEREST_RATES

Line 213: , CE_INTEREST_RATES IR

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
217: AND IR.EFFECTIVE_DATE >= p_from_date --'31-DEC-2003'

Line 270: , ce_interest_rates ir

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
274: and nvl(ibr.TO_BALANCE_AMOUNT, tmp.VALUE_DATED_BALANCE) <= tmp.VALUE_DATED_BALANCE

Line 283: , ce_interest_rates ir

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
287: and nvl(ibr.TO_BALANCE_AMOUNT, tmp2.VALUE_DATED_BALANCE) <= tmp.VALUE_DATED_BALANCE

Line 306: , ce_interest_rates ir

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
310: and ibr.balance_range_id = ir.balance_range_id

Line 313: from CE_INTEREST_RATES IR2

309: and ibr.TO_BALANCE_AMOUNT <= 0
310: and ibr.balance_range_id = ir.balance_range_id
311: and ir.effective_date=
312: (select max(ir2.effective_date)
313: from CE_INTEREST_RATES IR2
314: where ir2.effective_date <= p_balance_date_from --'31-DEC-2003' --max(BAB.BALANCE_DATE)
315: and ir2.balance_range_id = ir.BALANCE_RANGE_ID)
316: ;
317:

Line 347: from CE_INTEREST_RATES IR

343: select
344: nvl(FROM_BALANCE_AMOUNT, -1),
345: nvl(TO_BALANCE_AMOUNT, l_amount),
346: /* (select distinct ir.interest_rate
347: from CE_INTEREST_RATES IR
348: where ir.balance_range_id = IBR.BALANCE_RANGE_ID
349: and ir.effective_date =
350: (select max(ir2.effective_date)
351: from CE_INTEREST_RATES IR2

Line 351: from CE_INTEREST_RATES IR2

347: from CE_INTEREST_RATES IR
348: where ir.balance_range_id = IBR.BALANCE_RANGE_ID
349: and ir.effective_date =
350: (select max(ir2.effective_date)
351: from CE_INTEREST_RATES IR2
352: where ir2.effective_date <= p_balance_date_from --'31-DEC-2003' --max(BAB.BALANCE_DATE)
353: and ir2.balance_range_id = ir.BALANCE_RANGE_ID
354: )
355: ) INTEREST_RATES*/

Line 358: , ce_interest_rates ir

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
362: and ibr.balance_range_id = ir.balance_range_id

Line 365: from CE_INTEREST_RATES IR2

361: and ibr.FROM_BALANCE_AMOUNT >= 0
362: and ibr.balance_range_id = ir.balance_range_id
363: and ir.effective_date=
364: (select max(ir2.effective_date)
365: from CE_INTEREST_RATES IR2
366: where ir2.effective_date <= p_balance_date_from --'31-DEC-2003' --max(BAB.BALANCE_DATE)
367: and ir2.balance_range_id = ir.BALANCE_RANGE_ID)
368: ;
369:

Line 407: from CE_INTEREST_RATES IR

403: --, tmp.VALUE_DATED_BALANCE
404: , IBR.BALANCE_RANGE_ID
405: --, IR.INTEREST_RATE
406: , (select distinct ir.interest_rate
407: from CE_INTEREST_RATES IR
408: where ir.balance_range_id = IBR.BALANCE_RANGE_ID
409: and ir.effective_date =
410: (select max(ir2.effective_date)
411: from CE_INTEREST_RATES IR2

Line 411: from CE_INTEREST_RATES IR2

407: from CE_INTEREST_RATES IR
408: where ir.balance_range_id = IBR.BALANCE_RANGE_ID
409: and ir.effective_date =
410: (select max(ir2.effective_date)
411: from CE_INTEREST_RATES IR2
412: where ir2.effective_date <= tmp.from_date --p_from_date --max(BAB.BALANCE_DATE)
413: and ir2.balance_range_id = ir.BALANCE_RANGE_ID
414: )
415: ) INTEREST_RATES

Line 418: -- , CE_INTEREST_RATES IR

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
422: and tmp.VALUE_DATED_BALANCE >= nvl(IBR.FROM_BALANCE_AMOUNT , tmp.VALUE_DATED_BALANCE )

Line 445: from CE_INTEREST_RATES IR

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
446: where ir.balance_range_id = IBR.BALANCE_RANGE_ID
447: and ir.effective_date =
448: (select max(ir2.effective_date)
449: from CE_INTEREST_RATES IR2

Line 449: from CE_INTEREST_RATES IR2

445: from CE_INTEREST_RATES IR
446: where ir.balance_range_id = IBR.BALANCE_RANGE_ID
447: and ir.effective_date =
448: (select max(ir2.effective_date)
449: from CE_INTEREST_RATES IR2
450: where ir2.effective_date <= p_from_date --'31-DEC-2003' --max(BAB.BALANCE_DATE)
451: and ir2.balance_range_id = ir.BALANCE_RANGE_ID
452: )
453: ) INTEREST_RATES*/

Line 497: from CE_INTEREST_RATES IR

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
498: where ir.balance_range_id = IBR.BALANCE_RANGE_ID
499: and ir.effective_date =
500: (select max(ir2.effective_date)
501: from CE_INTEREST_RATES IR2

Line 501: from CE_INTEREST_RATES IR2

497: from CE_INTEREST_RATES IR
498: where ir.balance_range_id = IBR.BALANCE_RANGE_ID
499: and ir.effective_date =
500: (select max(ir2.effective_date)
501: from CE_INTEREST_RATES IR2
502: where ir2.effective_date <= BAB.BALANCE_DATE
503: and ir2.balance_range_id = ir.BALANCE_RANGE_ID
504: )
505: ) INTEREST_RATES*/

Line 570: , CE_INTEREST_RATES IR

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
574: AND IBR.BALANCE_RANGE_ID = IR.BALANCE_RANGE_ID

Line 722: , CE_INTEREST_RATES IR

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
726: AND cIS.INTEREST_SCHEDULE_ID = IBR.INTEREST_SCHEDULE_ID

Line 733: from CE_INTEREST_RATES IR2

729: and nvl(IBR.TO_BALANCE_AMOUNT, p_balance_amount ) >= p_balance_amount
730: and ir.balance_range_id = IBR.BALANCE_RANGE_ID
731: and ir.effective_date =
732: (select max(ir2.effective_date)
733: from CE_INTEREST_RATES IR2
734: where ir2.effective_date <= p_balance_date --'31-DEC-2003'
735: and ir2.balance_range_id = ir.BALANCE_RANGE_ID
736: ) ;
737: ELSE

Line 744: , CE_INTEREST_RATES IR

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
748: AND cIS.INTEREST_SCHEDULE_ID = IBR.INTEREST_SCHEDULE_ID

Line 755: from CE_INTEREST_RATES IR2

751: and IBR.TO_BALANCE_AMOUNT <= 0
752: and ir.balance_range_id = IBR.BALANCE_RANGE_ID
753: and ir.effective_date =
754: (select max(ir2.effective_date)
755: from CE_INTEREST_RATES IR2
756: where ir2.effective_date <= p_balance_date --'31-DEC-2003'
757: and ir2.balance_range_id = ir.BALANCE_RANGE_ID
758: ) ;
759: END IF;