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_INT_CALC_DETAILS_GT

Line 31: from CE_INT_CALC_DETAILS_GT

27: , TO_DATE
28: , VALUE_DATED_BALANCE
29: , nvl(INTEREST_RATE,0)
30: , INTEREST_CALC_DETAIL_ID
31: from CE_INT_CALC_DETAILS_GT
32: where INTEREST_SCHEDULE_ID = p_interest_schedule_id
33: --and BANK_ACCOUNT_ID = p_bank_account_id
34: and INTEREST_ACCT_TYPE = p_interest_acct_type
35: and CASHPOOL_ID = p_cashpool_id

Line 43: from CE_INT_CALC_DETAILS_GT

39: , TO_DATE
40: , VALUE_DATED_BALANCE
41: , nvl(INTEREST_RATE,0)
42: , INTEREST_CALC_DETAIL_ID
43: from CE_INT_CALC_DETAILS_GT
44: where INTEREST_SCHEDULE_ID = p_interest_schedule_id
45: and BANK_ACCOUNT_ID = p_bank_account_id
46: and INTEREST_ACCT_TYPE = p_interest_acct_type
47: and CASHPOOL_ID is null

Line 60: from CE_INT_CALC_DETAILS_GT

56: ) IS
57: select from_date
58: , rownum
59: , INTEREST_CALC_DETAIL_ID
60: from CE_INT_CALC_DETAILS_GT
61: where
62: INTEREST_SCHEDULE_ID = p_interest_schedule_id
63: --and BANK_ACCOUNT_ID = p_bank_account_id
64: and INTEREST_ACCT_TYPE = p_interest_acct_type

Line 70: from CE_INT_CALC_DETAILS_GT

66: UNION ALL
67: select from_date
68: , rownum
69: , INTEREST_CALC_DETAIL_ID
70: from CE_INT_CALC_DETAILS_GT
71: where
72: INTEREST_SCHEDULE_ID = p_interest_schedule_id
73: and BANK_ACCOUNT_ID = p_bank_account_id
74: and INTEREST_ACCT_TYPE = p_interest_acct_type

Line 88: from CE_INT_CALC_DETAILS_GT

84: ) IS
85: select from_date
86: , rownum
87: , INTEREST_CALC_DETAIL_ID
88: from CE_INT_CALC_DETAILS_GT
89: where
90: INTEREST_SCHEDULE_ID = p_interest_schedule_id
91: and BANK_ACCOUNT_ID = p_bank_account_id
92: and INTEREST_ACCT_TYPE = p_interest_acct_type

Line 193: from CE_INT_CALC_DETAILS_GT tmp

189: tmp2.BANK_ACCOUNT_ID
190: , IR.EFFECTIVE_DATE
191: , tmp2.VALUE_DATED_BALANCE
192: /* , (select distinct tmp.VALUE_DATED_BALANCE
193: from CE_INT_CALC_DETAILS_GT tmp
194: where tmp.bank_account_id = bab.bank_account_id
195: and tmp.balance_range_id = ir.balance_range_id
196: and tmp.INTEREST_SCHEDULE_ID = cis.interest_schedule_id
197: and tmp.interest_acct_type = p_interest_acct_type

Line 200: from CE_INT_CALC_DETAILS_GT tmp2

196: and tmp.INTEREST_SCHEDULE_ID = cis.interest_schedule_id
197: and tmp.interest_acct_type = p_interest_acct_type
198: and tmp.from_date =
199: (select max(tmp2.from_date)
200: from CE_INT_CALC_DETAILS_GT tmp2
201: where tmp2.from_date < ir.effective_date -- tmp.from_date
202: and tmp.bank_account_id = tmp2.bank_account_id
203: and tmp2.interest_acct_type = p_interest_acct_type
204: )

Line 210: CE_INT_CALC_DETAILS_GT tmp2 --, CE_BANK_ACCOUNTS BA

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
214: WHERE

Line 239: from CE_INT_CALC_DETAILS_GT tmp

235: and tmp2.interest_acct_type = p_interest_acct_type
236: and cIS.INTEREST_SCHEDULE_ID = tmp2.INTEREST_SCHEDULE_ID
237: and IR.EFFECTIVE_DATE > tmp2.from_date
238: and tmp2.from_date = (select max(tmp.from_date)
239: from CE_INT_CALC_DETAILS_GT tmp
240: where tmp.from_date < ir.effective_date
241: and tmp.bank_account_id = tmp2.bank_account_id
242: and tmp.interest_acct_type = p_interest_acct_type
243: )

Line 244: and not exists (select tmp.from_date from CE_INT_CALC_DETAILS_GT tmp

240: where tmp.from_date < ir.effective_date
241: and tmp.bank_account_id = tmp2.bank_account_id
242: and tmp.interest_acct_type = p_interest_acct_type
243: )
244: and not exists (select tmp.from_date from CE_INT_CALC_DETAILS_GT tmp
245: where tmp.from_date = IR.EFFECTIVE_DATE
246: and tmp.bank_account_id = tmp2.BANK_ACCOUNT_ID
247: and tmp.from_date>=p_from_date --'31-DEC-2003'
248: and tmp.from_date<=p_to_date --'31-JAN-2004'

Line 252: and exists (select tmp.balance_range_id from CE_INT_CALC_DETAILS_GT tmp

248: and tmp.from_date<=p_to_date --'31-JAN-2004'
249: and tmp.INTEREST_SCHEDULE_ID = p_interest_schedule_id --10002
250: and tmp.interest_acct_type = p_interest_acct_type
251: )
252: and exists (select tmp.balance_range_id from CE_INT_CALC_DETAILS_GT tmp
253: where tmp.balance_range_id = IR.BALANCE_RANGE_ID
254: and tmp.bank_account_id = tmp2.BANK_ACCOUNT_ID
255: and tmp.from_date>=p_from_date --'31-DEC-2003'
256: and tmp.from_date<=p_to_date --'31-JAN-2004'

Line 271: , CE_INT_CALC_DETAILS_GT tmp

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
275: and tmp.interest_rate is null

Line 284: , CE_INT_CALC_DETAILS_GT tmp2

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
288: and tmp2.interest_rate is null

Line 416: from CE_INT_CALC_DETAILS_GT tmp

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
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

Line 470: and not exists (select tmp.from_date from CE_INT_CALC_DETAILS_GT tmp

466: AND BAB.BALANCE_DATE <= p_from_date --'31-DEC-2003'
467: --and BAB.VALUE_DATED_BALANCE >= nvl(IBR.FROM_BALANCE_AMOUNT, BAB.VALUE_DATED_BALANCE )
468: --and BAB.VALUE_DATED_BALANCE <= nvl(IBR.TO_BALANCE_AMOUNT, BAB.VALUE_DATED_BALANCE )
469: AND BAB.BANK_ACCOUNT_ID = p_bank_account_id --10001
470: and not exists (select tmp.from_date from CE_INT_CALC_DETAILS_GT tmp
471: where tmp.from_date = p_from_date --max(BAB.BALANCE_DATE)
472: --and tmp.bank_account_id = BAB.BANK_ACCOUNT_ID
473: and tmp.from_date>=p_from_date --'31-DEC-2003'
474: and tmp.from_date<=p_to_date --'31-JAN-2004'

Line 524: and not exists (select tmp.from_date from CE_INT_CALC_DETAILS_GT tmp

520: AND BAB.BALANCE_DATE <> p_from_date --'31-DEC-2003'
521: --and BAB.VALUE_DATED_BALANCE >= nvl(IBR.FROM_BALANCE_AMOUNT , BAB.VALUE_DATED_BALANCE )
522: --and BAB.VALUE_DATED_BALANCE <= nvl(IBR.TO_BALANCE_AMOUNT, BAB.VALUE_DATED_BALANCE )
523: AND BAB.BANK_ACCOUNT_ID = p_bank_account_id --10001
524: and not exists (select tmp.from_date from CE_INT_CALC_DETAILS_GT tmp
525: where tmp.from_date = BAB.BALANCE_DATE
526: --and tmp.bank_account_id = BAB.BANK_ACCOUNT_ID
527: and tmp.from_date>=p_from_date --'31-DEC-2003'
528: and tmp.from_date<=p_to_date --'31-JAN-2004'

Line 548: from CE_INT_CALC_DETAILS_GT tmp

544: tmpx.BANK_ACCOUNT_ID
545: , IR.EFFECTIVE_DATE
546: , tmpx.VALUE_DATED_BALANCE
547: /* , (select distinct tmp.VALUE_DATED_BALANCE
548: from CE_INT_CALC_DETAILS_GT tmp
549: where tmp.bank_account_id = tmpx.bank_account_id
550: and tmp.balance_range_id = ir.balance_range_id
551: and tmp.INTEREST_SCHEDULE_ID = cis.interest_schedule_id
552: and tmp.interest_acct_type = p_interest_acct_type

Line 556: from CE_INT_CALC_DETAILS_GT tmp2

552: and tmp.interest_acct_type = p_interest_acct_type
553: and tmp.cashpool_id = p_cashpool_id
554: and tmp.from_date =
555: (select max(tmp2.from_date)
556: from CE_INT_CALC_DETAILS_GT tmp2
557: where tmp2.from_date < ir.effective_date -- tmp.from_date
558: and tmp.bank_account_id = tmp2.bank_account_id
559: and tmp2.interest_acct_type = p_interest_acct_type
560: and tmp2.cashpool_id = p_cashpool_id

Line 571: , CE_INT_CALC_DETAILS_GT tmpx

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

Line 597: from CE_INT_CALC_DETAILS_GT tmp

593: and tmpx.interest_acct_type = p_interest_acct_type
594: and CIS.INTEREST_SCHEDULE_ID = tmpx.INTEREST_SCHEDULE_ID
595: and IR.EFFECTIVE_DATE > tmpx.from_date
596: and tmpx.from_date = (select max(tmp.from_date)
597: from CE_INT_CALC_DETAILS_GT tmp
598: where tmp.from_date < ir.effective_date
599: and tmp.bank_account_id = tmpx.bank_account_id
600: and tmp.interest_acct_type = p_interest_acct_type
601: )

Line 602: and not exists (select tmp.from_date from CE_INT_CALC_DETAILS_GT tmp

598: where tmp.from_date < ir.effective_date
599: and tmp.bank_account_id = tmpx.bank_account_id
600: and tmp.interest_acct_type = p_interest_acct_type
601: )
602: and not exists (select tmp.from_date from CE_INT_CALC_DETAILS_GT tmp
603: where tmp.from_date = IR.EFFECTIVE_DATE
604: and tmp.bank_account_id = tmpx.BANK_ACCOUNT_ID
605: --and tmp.bank_account_id = BAB.BANK_ACCOUNT_ID
606: and tmp.from_date>=p_from_date --'31-DEC-2003'

Line 611: and exists (select tmp.balance_range_id from CE_INT_CALC_DETAILS_GT tmp

607: and tmp.from_date<=p_to_date --'31-JAN-2004'
608: and tmp.INTEREST_SCHEDULE_ID = p_interest_schedule_id --10002
609: and tmp.interest_acct_type = p_interest_acct_type
610: )
611: and exists (select tmp.balance_range_id from CE_INT_CALC_DETAILS_GT tmp
612: where tmp.balance_range_id = IR.BALANCE_RANGE_ID
613: and tmp.bank_account_id = tmpx.BANK_ACCOUNT_ID
614: --and tmp.bank_account_id = BAB.BANK_ACCOUNT_ID
615: and tmp.from_date>=p_from_date --'31-DEC-2003'

Line 792: | CE_INT_CALC_DETAILS_GT |

788: | int_cal_detail_main |
789: | |
790: | DESCRIPTION |
791: | Delete accounts from |
792: | CE_INT_CALC_DETAILS_GT |
793: --------------------------------------------------------------------- */
794: PROCEDURE delete_schedule_account( p_interest_schedule_id number,
795: p_bank_account_id number,
796: p_interest_acct_type varchar2,

Line 827: DELETE CE_INT_CALC_DETAILS_GT

823: IF (p_interest_acct_type in ('BANK_ACCOUNT', 'TREASURY')) THEN
824: IF l_DEBUG in ('Y', 'C') THEN
825: cep_standard.debug('delete p_interest_acct_type BANK_ACCOUNT');
826: END IF;
827: DELETE CE_INT_CALC_DETAILS_GT
828: WHERE INTEREST_SCHEDULE_ID = p_interest_schedule_id
829: and BANK_ACCOUNT_ID = p_bank_account_id
830: AND INTEREST_ACCT_TYPE = p_interest_acct_type;
831: ELSIF (p_interest_acct_type = 'NOTIONAL') THEN

Line 835: DELETE CE_INT_CALC_DETAILS_GT

831: ELSIF (p_interest_acct_type = 'NOTIONAL') THEN
832: IF l_DEBUG in ('Y', 'C') THEN
833: cep_standard.debug('delete p_interest_acct_type NOTIONAL');
834: END IF;
835: DELETE CE_INT_CALC_DETAILS_GT
836: WHERE INTEREST_SCHEDULE_ID = p_interest_schedule_id
837: --and BANK_ACCOUNT_ID = p_bank_account_id
838: AND CASHPOOL_ID = p_cashpool_id
839: AND INTEREST_ACCT_TYPE = p_interest_acct_type;

Line 866: | CE_INT_CALC_DETAILS_GT |

862: | int_cal_detail_main |
863: | |
864: | DESCRIPTION |
865: | Get Interest Calculated balances information and insert in |
866: | CE_INT_CALC_DETAILS_GT |
867: --------------------------------------------------------------------- */
868: PROCEDURE get_balance_info( p_from_date date,
869: p_to_date date,
870: p_interest_schedule_id number,

Line 939: insert into CE_INT_CALC_DETAILS_GT

935: cep_standard.debug('y_interest_rate = '|| y_interest_rate);
936: cep_standard.debug('y_first_row = '|| y_first_row);
937: cep_standard.debug('y_record_from = '|| y_record_from);
938: END IF;
939: insert into CE_INT_CALC_DETAILS_GT
940: (INTEREST_CALC_DETAIL_ID,
941: INTEREST_SCHEDULE_ID, BANK_ACCOUNT_ID, FROM_DATE, TO_DATE,
942: VALUE_DATED_BALANCE, NUMBER_OF_DAYS , INTEREST_AMOUNT,INTEREST_RATE,
943: BALANCE_RANGE_ID, RECORD_FROM,

Line 948: ( CE_INT_CALC_DETAILS_GT_S.nextval,

944: INTEREST_ACCT_TYPE, CASHPOOL_ID,
945: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,
946: LAST_UPDATE_LOGIN)
947: values
948: ( CE_INT_CALC_DETAILS_GT_S.nextval,
949: p_interest_schedule_id, p_bank_account_id, y_balance_date_from, null,
950: y_int_calc_balance, null, null, y_interest_rate,
951: y_balance_range_id, y_record_from,
952: p_interest_acct_type, p_cashpool_id,

Line 956: cep_standard.debug('insert into CE_INT_CALC_DETAILS_GT completed ');

952: p_interest_acct_type, p_cashpool_id,
953: sysdate, -1, sysdate, -1, null);
954:
955: IF l_DEBUG in ('Y', 'C') THEN
956: cep_standard.debug('insert into CE_INT_CALC_DETAILS_GT completed ');
957: END IF;
958: END LOOP; --balance_info
959: p_row_count := balance_info%ROWCOUNT;
960: IF l_DEBUG in ('Y', 'C') THEN

Line 989: | CE_INT_CALC_DETAILS_GT |

985: | int_cal_detail_main |
986: | |
987: | DESCRIPTION |
988: | Get Interest Calculated balances information and insert in |
989: | CE_INT_CALC_DETAILS_GT |
990: --------------------------------------------------------------------- */
991: PROCEDURE get_balance_pool_info( p_from_date date,
992: p_to_date date,
993: p_interest_schedule_id number,

Line 1063: insert into CE_INT_CALC_DETAILS_GT

1059: cep_standard.debug('y_interest_rate = '|| y_interest_rate);
1060: cep_standard.debug('y_first_row = '|| y_first_row);
1061: cep_standard.debug('y_record_from = '|| y_record_from);
1062: END IF;
1063: insert into CE_INT_CALC_DETAILS_GT
1064: (INTEREST_CALC_DETAIL_ID,
1065: INTEREST_SCHEDULE_ID, BANK_ACCOUNT_ID, FROM_DATE, TO_DATE,
1066: VALUE_DATED_BALANCE, NUMBER_OF_DAYS , INTEREST_AMOUNT,INTEREST_RATE,
1067: BALANCE_RANGE_ID, RECORD_FROM,

Line 1072: ( CE_INT_CALC_DETAILS_GT_S.nextval,

1068: INTEREST_ACCT_TYPE, CASHPOOL_ID,
1069: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,
1070: LAST_UPDATE_LOGIN)
1071: values
1072: ( CE_INT_CALC_DETAILS_GT_S.nextval,
1073: p_interest_schedule_id, p_bank_account_id, y_balance_date_from, null,
1074: y_int_calc_balance, null, null, y_interest_rate,
1075: y_balance_range_id, y_record_from,
1076: p_interest_acct_type, p_cashpool_id,

Line 1080: cep_standard.debug('insert into CE_INT_CALC_DETAILS_GT completed ');

1076: p_interest_acct_type, p_cashpool_id,
1077: sysdate, -1, sysdate, -1, null);
1078:
1079: IF l_DEBUG in ('Y', 'C') THEN
1080: cep_standard.debug('insert into CE_INT_CALC_DETAILS_GT completed ');
1081: END IF;
1082: END LOOP; --balance_pool_info
1083: p_row_count := balance_pool_info%ROWCOUNT;
1084: IF l_DEBUG in ('Y', 'C') THEN

Line 1190: insert into CE_INT_CALC_DETAILS_GT

1186: cep_standard.debug('y_balance_range_id = '|| y_balance_range_id);
1187: cep_standard.debug('y_interest_rate = '|| y_interest_rate );
1188:
1189: END IF;
1190: insert into CE_INT_CALC_DETAILS_GT
1191: (INTEREST_CALC_DETAIL_ID,
1192: INTEREST_SCHEDULE_ID, BANK_ACCOUNT_ID, FROM_DATE, TO_DATE,
1193: VALUE_DATED_BALANCE, NUMBER_OF_DAYS , INTEREST_AMOUNT,INTEREST_RATE,
1194: BALANCE_RANGE_ID, RECORD_FROM,

Line 1199: ( CE_INT_CALC_DETAILS_GT_S.nextval,

1195: INTEREST_ACCT_TYPE, CASHPOOL_ID,
1196: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,
1197: LAST_UPDATE_LOGIN)
1198: values
1199: ( CE_INT_CALC_DETAILS_GT_S.nextval,
1200: p_interest_schedule_id, p_bank_account_id, y_balance_date_from, null,
1201: y_int_calc_balance, null, null, y_interest_rate,
1202: y_balance_range_id, y_record_from,
1203: p_interest_acct_type, p_cashpool_id,

Line 1316: insert into CE_INT_CALC_DETAILS_GT

1312: cep_standard.debug('y_balance_range_id = '|| y_balance_range_id);
1313: cep_standard.debug('y_interest_rate = '|| y_interest_rate );
1314:
1315: END IF;
1316: insert into CE_INT_CALC_DETAILS_GT
1317: (INTEREST_CALC_DETAIL_ID,
1318: INTEREST_SCHEDULE_ID, BANK_ACCOUNT_ID, FROM_DATE, TO_DATE,
1319: VALUE_DATED_BALANCE, NUMBER_OF_DAYS , INTEREST_AMOUNT,INTEREST_RATE,
1320: BALANCE_RANGE_ID, RECORD_FROM,

Line 1325: ( CE_INT_CALC_DETAILS_GT_S.nextval,

1321: INTEREST_ACCT_TYPE, CASHPOOL_ID,
1322: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,
1323: LAST_UPDATE_LOGIN)
1324: values
1325: ( CE_INT_CALC_DETAILS_GT_S.nextval,
1326: p_interest_schedule_id, p_bank_account_id, y_balance_date_from, null,
1327: y_int_calc_balance, null, null, y_interest_rate,
1328: y_balance_range_id, y_record_from,
1329: p_interest_acct_type, p_cashpool_id,

Line 1415: update CE_INT_CALC_DETAILS_GT

1411: cep_standard.debug('y_interest_calc_detail_id = '|| y_interest_calc_detail_id);
1412:
1413: END IF;
1414:
1415: update CE_INT_CALC_DETAILS_GT
1416: set INTEREST_RATE = y_interest_rate,
1417: LAST_UPDATE_DATE = sysdate
1418: where from_date = y_balance_date_from
1419: and bank_account_id = p_bank_account_id

Line 1453: | on CE_INT_CALC_DETAILS_GT for cashpool accounts only |

1449: | int_cal_detail_main |
1450: | |
1451: | DESCRIPTION |
1452: | Use to set the balance range id and interest rate
1453: | on CE_INT_CALC_DETAILS_GT for cashpool accounts only |
1454: | |
1455: --------------------------------------------------------------------- */
1456: PROCEDURE set_range_and_rate(p_from_date date,
1457: p_to_date date,

Line 1506: update CE_INT_CALC_DETAILS_GT

1502: cep_standard.debug('y_interest_rate = '|| y_interest_rate);
1503: cep_standard.debug('y_interest_calc_detail_id = '|| y_interest_calc_detail_id);
1504: END IF;
1505:
1506: update CE_INT_CALC_DETAILS_GT
1507: set BALANCE_RANGE_ID = y_balance_range_id,
1508: INTEREST_RATE = y_interest_rate
1509: where
1510: bank_account_id = p_bank_account_id

Line 1543: | Use to set the TO_DATE on CE_INT_CALC_DETAILS_GT |

1539: | CALLED BY |
1540: | int_cal_detail_main |
1541: | |
1542: | DESCRIPTION |
1543: | Use to set the TO_DATE on CE_INT_CALC_DETAILS_GT |
1544: | |
1545: --------------------------------------------------------------------- */
1546: PROCEDURE set_end_date( p_from_date date,
1547: p_to_date date,

Line 1608: update CE_INT_CALC_DETAILS_GT

1604: cep_standard.debug(' i = '|| i);
1605:
1606: END IF;
1607:
1608: update CE_INT_CALC_DETAILS_GT
1609: set to_date = y_end_date,
1610: LAST_UPDATE_DATE = sysdate
1611: where from_date = x_balance_date_from
1612: --and bank_account_id = p_bank_account_id

Line 1652: | Use to set the INTEREST_RATE on CE_INT_CALC_DETAILS_GT |

1648: | CALLED BY |
1649: | int_cal_xtr |
1650: | |
1651: | DESCRIPTION |
1652: | Use to set the INTEREST_RATE on CE_INT_CALC_DETAILS_GT |
1653: | |
1654: --------------------------------------------------------------------- */
1655: PROCEDURE set_int_rate( p_from_date date,
1656: p_to_date date,

Line 1700: update CE_INT_CALC_DETAILS_GT

1696: IF l_DEBUG in ('Y', 'C') THEN
1697: cep_standard.debug('y_interest_calc_detail_id = '|| y_interest_calc_detail_id);
1698: END IF;
1699:
1700: update CE_INT_CALC_DETAILS_GT
1701: set INTEREST_RATE = p_interest_rate
1702: where interest_calc_detail_id = y_interest_calc_detail_id;
1703:
1704:

Line 2161: update CE_INT_CALC_DETAILS_GT

2157: END IF;
2158:
2159: IF (x_basis = 'STEP') THEN
2160: --x_new_interest_rate := (x_interest_amount/(nvl((x_int_calc_balance * x_days_over_year),1) * 100));
2161: update CE_INT_CALC_DETAILS_GT
2162: set interest_amount = x_interest_amount_round,
2163: NUMBER_OF_DAYS = x_days,
2164: interest_rate = x_new_interest_rate,
2165: LAST_UPDATE_DATE = sysdate

Line 2172: update CE_INT_CALC_DETAILS_GT

2168: --and bank_account_id = p_bank_account_id
2169: and INTEREST_SCHEDULE_ID = p_interest_schedule_id
2170: and interest_calc_detail_id = x_interest_calc_detail_id ;
2171: ELSE
2172: update CE_INT_CALC_DETAILS_GT
2173: set interest_amount = x_interest_amount_round,
2174: NUMBER_OF_DAYS = x_days,
2175: LAST_UPDATE_DATE = sysdate
2176: where

Line 2305: from CE_INT_CALC_DETAILS_GT

2301: p_interest_acct_type, p_cashpool_id );
2302:
2303: select sum(INTEREST_AMOUNT)
2304: into p_interest_amount
2305: from CE_INT_CALC_DETAILS_GT
2306: where INTEREST_SCHEDULE_ID = p_interest_schedule_id
2307: and BANK_ACCOUNT_ID = p_bank_account_id
2308: and INTEREST_ACCT_TYPE = p_interest_acct_type
2309: and FROM_DATE >= p_from_date

Line 2498: from CE_INT_CALC_DETAILS_GT

2494:
2495: --bug 5479708, removed last date range
2496: if (p_cashpool_id is null) THEN
2497: select count(*) into p_num_of_range
2498: from CE_INT_CALC_DETAILS_GT
2499: where
2500: INTEREST_SCHEDULE_ID = p_interest_schedule_id
2501: and BANK_ACCOUNT_ID = p_bank_account_id
2502: and INTEREST_ACCT_TYPE = p_interest_acct_type

Line 2506: delete CE_INT_CALC_DETAILS_GT

2502: and INTEREST_ACCT_TYPE = p_interest_acct_type
2503: and CASHPOOL_ID is null;
2504:
2505: IF (p_num_of_range > 1) THEN
2506: delete CE_INT_CALC_DETAILS_GT
2507: where
2508: INTEREST_SCHEDULE_ID = p_interest_schedule_id
2509: and BANK_ACCOUNT_ID = p_bank_account_id
2510: and INTEREST_ACCT_TYPE = p_interest_acct_type

Line 2518: from CE_INT_CALC_DETAILS_GT

2514: END IF;
2515:
2516: else -- p_cashpool_id is not null
2517: select count(*) into p_num_of_range
2518: from CE_INT_CALC_DETAILS_GT
2519: where INTEREST_SCHEDULE_ID = p_interest_schedule_id
2520: --and BANK_ACCOUNT_ID = p_bank_account_id
2521: and INTEREST_ACCT_TYPE = p_interest_acct_type
2522: and CASHPOOL_ID = p_cashpool_id;

Line 2525: delete CE_INT_CALC_DETAILS_GT

2521: and INTEREST_ACCT_TYPE = p_interest_acct_type
2522: and CASHPOOL_ID = p_cashpool_id;
2523:
2524: IF (p_num_of_range > 1) THEN
2525: delete CE_INT_CALC_DETAILS_GT
2526: where INTEREST_SCHEDULE_ID = p_interest_schedule_id
2527: --and BANK_ACCOUNT_ID = p_bank_account_id
2528: and INTEREST_ACCT_TYPE = p_interest_acct_type
2529: and CASHPOOL_ID = p_cashpool_id