[Home] [Help]
427: ,sched.fee_description
428: from lns_fee_schedules sched
429: ,lns_fees fees
430: ,lns_amortization_lines lines
431: ,lns_amortization_scheds am
432: where fees.fee_id = sched.fee_id
433: and lines.fee_schedule_id = sched.fee_schedule_id
434: and lines.amortization_schedule_id = am.amortization_schedule_id
435: and am.amortization_schedule_id =
433: and lines.fee_schedule_id = sched.fee_schedule_id
434: and lines.amortization_schedule_id = am.amortization_schedule_id
435: and am.amortization_schedule_id =
436: (select max(am2.amortization_schedule_id)
437: from lns_amortization_scheds am2
438: where am2.reversed_flag = 'Y'
439: and am2.loan_id = p_loan_id )
440: and am.reamortization_amount is null
441: and sched.fee_installment = p_installment
1406: -- NOT NULL
1407: -- and disb_header_id is null
1408: and (not exists
1409: (select 'X'
1410: from lns_amortization_scheds am
1411: ,lns_amortization_lines lines
1412: where lines.loan_id = p_loan_id
1413: and lines.fee_schedule_id = sched.fee_schedule_id
1414: and am.loan_id = lines.loan_id
1415: and NVL(am.reversed_flag, 'N') = 'N'
1416: and am.payment_number = p_installment)
1417: or exists
1418: (select 'X'
1419: from lns_amortization_scheds am
1420: ,lns_amortization_lines lines
1421: where lines.loan_id = p_loan_id
1422: and lines.fee_schedule_id = sched.fee_schedule_id
1423: and am.loan_id = lines.loan_id
2411: and fees.fee_category = p_category
2412: and fees.fee_type = p_type
2413: and (exists
2414: (select 'X'
2415: from lns_amortization_scheds am
2416: ,lns_amortization_lines lines
2417: where am.loan_id = p_loan_id
2418: and am.amortization_schedule_id = lines.amortization_schedule_id
2419: and lines.fee_schedule_id = sched.fee_schedule_id
2910:
2911: -- get the amount overdue for the last installment (P or P+I depends on fee structure)
2912: vPlSql := 'select ' ||
2913: ' nvl(sum(amount_due_remaining),0) ' ||
2914: ' from lns_amortization_scheds am ' ||
2915: ' ,ar_payment_schedules ps ' ||
2916: ' ,lns_fee_assignments fass ' ||
2917: ' ,lns_fees fees ' ||
2918: ' where am.loan_id = :p_loan_id and ' ||