eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_FUNDING_PUB dependencies on LNS_FEE_ASSIGNMENTS

Line 5310: from lns_fee_assignments

5306:
5307: -- check to start billing for 0-th installment
5308: CURSOR do_billing_cur(P_LOAN_ID number) IS
5309: select nvl(count(1),0)
5310: from lns_fee_assignments
5311: where begin_installment_number = 0
5312: and end_installment_number = 0
5313: and end_date_active is null
5314: and billing_option = 'ORIGINATION'

Line 5316: -- Bug#6613647, The loanId is NULL if for the disbFees in lns_fee_assignments.

5312: and end_installment_number = 0
5313: and end_date_active is null
5314: and billing_option = 'ORIGINATION'
5315: and (loan_id = P_LOAN_ID
5316: -- Bug#6613647, The loanId is NULL if for the disbFees in lns_fee_assignments.
5317: -- So to check any existed 0th installment fees for a loan, also check existed fees for disb_header_id.
5318: OR disb_header_id in (select disb_header_id from lns_disb_headers where loan_id = P_LOAN_ID) -- Bug#6613647
5319: );
5320: