APPS.LNS_FEE_ENGINE dependencies on LNS_AMORTIZATION_LINES

Line 392: ,lns_amortization_lines lines

388: ,sched.fee_description
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

Line 1564: ,lns_amortization_lines lines

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
1568: and NVL(am.reversed_flag, 'N') = 'N'

Line 1573: ,lns_amortization_lines lines

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
1577: and am.reversed_flag = 'Y'

Line 1797: ,lns_amortization_lines lines

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
1801: and am.payment_number = c_installment));

Line 2775: ,lns_amortization_lines lines

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
2779: and NVL(am.reversed_flag, 'N') = 'N'

Line 3818: ,lns_amortization_lines lines

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
3822: and NVL(am.reversed_flag, 'N') = 'N'

Line 3825: from lns_amortization_lines amlines2

3821: and am.loan_id = lines.loan_id
3822: and NVL(am.reversed_flag, 'N') = 'N'
3823: and am.payment_number = c_installment
3824: and am.amortization_schedule_id = (select max(amortization_schedule_id)
3825: from lns_amortization_lines amlines2
3826: where amlines2.fee_schedule_id = lines.fee_schedule_id)
3827: )
3828: or exists
3829: (select 'X'

Line 3831: ,lns_amortization_lines lines

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
3835: and am.reversed_flag = 'Y'

Line 3838: from lns_amortization_lines amlines2

3834: and am.loan_id = lines.loan_id
3835: and am.reversed_flag = 'Y'
3836: and am.payment_number = c_installment
3837: and am.amortization_schedule_id = (select max(amortization_schedule_id)
3838: from lns_amortization_lines amlines2
3839: where amlines2.fee_schedule_id = lines.fee_schedule_id)
3840: ));
3841:
3842: