APPS.LNS_FEE_ENGINE dependencies on LNS_AMORTIZATION_SCHEDS

Line 393: ,lns_amortization_scheds am

389: ,nvl(sched.phase, 'TERM')
390: from lns_fee_schedules sched
391: ,lns_fees fees
392: ,lns_amortization_lines lines
393: ,lns_amortization_scheds am
394: where fees.fee_id = sched.fee_id
395: and lines.fee_schedule_id = sched.fee_schedule_id
396: and lines.amortization_schedule_id = am.amortization_schedule_id
397: and am.amortization_schedule_id =

Line 399: from lns_amortization_scheds am2

395: and lines.fee_schedule_id = sched.fee_schedule_id
396: and lines.amortization_schedule_id = am.amortization_schedule_id
397: and am.amortization_schedule_id =
398: (select max(am2.amortization_schedule_id)
399: from lns_amortization_scheds am2
400: where am2.reversed_flag = 'Y'
401: and am2.loan_id = c_loan_id )
402: and am.reamortization_amount is null
403: and sched.fee_installment = c_installment

Line 1563: from lns_amortization_scheds am

1559: -- NOT NULL
1560: -- and disb_header_id is null
1561: and (not exists
1562: (select 'X'
1563: from lns_amortization_scheds am
1564: ,lns_amortization_lines lines
1565: where lines.loan_id = c_loan_id
1566: and lines.fee_schedule_id = sched.fee_schedule_id
1567: and am.loan_id = lines.loan_id

Line 1572: from lns_amortization_scheds am

1568: and NVL(am.reversed_flag, 'N') = 'N'
1569: and am.payment_number = c_installment)
1570: or exists
1571: (select 'X'
1572: from lns_amortization_scheds am
1573: ,lns_amortization_lines lines
1574: where lines.loan_id = c_loan_id
1575: and lines.fee_schedule_id = sched.fee_schedule_id
1576: and am.loan_id = lines.loan_id

Line 1796: from lns_amortization_scheds am

1792: and active_flag = 'Y'
1793: and billed_flag = 'N' -- deduce this based on parent records
1794: and (not exists
1795: (select 'X'
1796: from lns_amortization_scheds am
1797: ,lns_amortization_lines lines
1798: where lines.loan_id = c_loan_id
1799: and lines.fee_schedule_id = sched.fee_schedule_id
1800: and am.loan_id = lines.loan_id

Line 2774: from lns_amortization_scheds am

2770: and nvl(sched.phase, 'TERM') = c_phase
2771: and fees.BILLING_OPTION = nvl(C_BILLING_OPTION, fees.BILLING_OPTION)
2772: and (exists
2773: (select 'X'
2774: from lns_amortization_scheds am
2775: ,lns_amortization_lines lines
2776: where am.loan_id = c_loan_id
2777: and am.amortization_schedule_id = lines.amortization_schedule_id
2778: and lines.fee_schedule_id = sched.fee_schedule_id

Line 3328: from LNS_AMORTIZATION_SCHEDS

3324: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
3325:
3326: CURSOR last_instal_cur(P_LOAN_ID number, p_payment_number number) IS
3327: select DUE_DATE
3328: from LNS_AMORTIZATION_SCHEDS
3329: where LOAN_ID = P_LOAN_ID
3330: and PAYMENT_NUMBER = p_payment_number
3331: and PARENT_AMORTIZATION_ID is null
3332: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N');

Line 3817: from lns_amortization_scheds am

3813: and active_flag = 'Y'
3814: and billed_flag = c_billed_flag
3815: and (not exists
3816: (select 'X'
3817: from lns_amortization_scheds am
3818: ,lns_amortization_lines lines
3819: where lines.loan_id = c_loan_id
3820: and lines.fee_schedule_id = sched.fee_schedule_id
3821: and am.loan_id = lines.loan_id

Line 3830: from lns_amortization_scheds am

3826: where amlines2.fee_schedule_id = lines.fee_schedule_id)
3827: )
3828: or exists
3829: (select 'X'
3830: from lns_amortization_scheds am
3831: ,lns_amortization_lines lines
3832: where lines.loan_id = c_loan_id
3833: and lines.fee_schedule_id = sched.fee_schedule_id
3834: and am.loan_id = lines.loan_id