DBA Data[Home] [Help]

APPS.LNS_FEE_ASSIGNMENT_PUB dependencies on LNS_AMORTIZATION_SCHEDS

Line 1447: from lns_amortization_scheds am

1443: AND sched.ACTIVE_FLAG = 'Y'
1444: AND sched.BILLED_FLAG = 'N'
1445: AND (NOT EXISTS
1446: (select 'X'
1447: from lns_amortization_scheds am
1448: ,lns_amortization_lines lines
1449: where lines.loan_id = c_loan_id
1450: and lines.fee_schedule_id = sched.fee_schedule_id
1451: and am.loan_id = lines.loan_id

Line 1457: from lns_amortization_scheds am

1453: --and am.payment_number = p_installment
1454: )
1455: or EXISTS
1456: (select 'X'
1457: from lns_amortization_scheds am
1458: ,lns_amortization_lines lines
1459: where lines.loan_id = c_loan_id
1460: and lines.fee_schedule_id = sched.fee_schedule_id
1461: and am.loan_id = lines.loan_id