APPS.LNS_LOAN_PUB dependencies on LNS_RATE_SCHEDULES

Line 2862: l_rate_open_rec lns_rate_schedules%ROWTYPE;

2858: l_prin_pay_in_arrears_bool boolean;
2859:
2860: l_loan_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
2861: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
2862: l_rate_open_rec lns_rate_schedules%ROWTYPE;
2863: l_participant_rec LNS_PARTICIPANTS_PUB.loan_participant_rec_type;
2864: l_custom_tbl lns_custom_pub.custom_tbl;
2865: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
2866: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

Line 3836: insert into LNS_RATE_SCHEDULES

3832: -- Create Term Rate Schedule Records
3833: FOR l_count IN 1 .. P_TERM_RATES_TBL.COUNT
3834: LOOP
3835: BEGIN
3836: insert into LNS_RATE_SCHEDULES
3837: (RATE_ID
3838: ,TERM_ID
3839: ,INDEX_RATE
3840: ,SPREAD

Line 3857: (LNS_RATE_SCHEDULES_S.nextval

3853: ,INTEREST_ONLY_FLAG
3854: ,PHASE
3855: ,FLOATING_FLAG)
3856: VALUES
3857: (LNS_RATE_SCHEDULES_S.nextval
3858: ,l_term_rec.term_id
3859: ,P_TERM_RATES_TBL(l_Count).INDEX_RATE
3860: ,nvl(P_TERM_RATES_TBL(l_Count).SPREAD, 0)
3861: ,(P_TERM_RATES_TBL(l_Count).INDEX_RATE + nvl(P_TERM_RATES_TBL(l_Count).SPREAD, 0))

Line 3895: insert into LNS_RATE_SCHEDULES

3891: IF l_product_rec.multiple_funding_flag = 'Y' THEN
3892: FOR l_count IN 1 .. P_OPEN_RATES_TBL.COUNT
3893: LOOP
3894: BEGIN
3895: insert into LNS_RATE_SCHEDULES
3896: (RATE_ID
3897: ,TERM_ID
3898: ,INDEX_RATE
3899: ,SPREAD

Line 3916: (LNS_RATE_SCHEDULES_S.nextval

3912: ,INTEREST_ONLY_FLAG
3913: ,PHASE
3914: ,FLOATING_FLAG)
3915: VALUES
3916: (LNS_RATE_SCHEDULES_S.nextval
3917: ,l_term_rec.term_id
3918: ,P_OPEN_RATES_TBL(l_Count).INDEX_RATE
3919: ,nvl(P_OPEN_RATES_TBL(l_Count).SPREAD, 0)
3920: ,(P_OPEN_RATES_TBL(l_Count).INDEX_RATE + nvl(P_OPEN_RATES_TBL(l_Count).SPREAD, 0))