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 5613: from lns_fee_assignments

5609:
5610: -- check to start billing for 0-th installment
5611: CURSOR do_billing_cur(C_LOAN_ID number, C_PHASE varchar2) IS
5612: select nvl(count(1),0)
5613: from lns_fee_assignments
5614: where begin_installment_number = 0
5615: and end_installment_number = 0
5616: and end_date_active is null
5617: and (billing_option = 'ORIGINATION'

Line 5645: from lns_fee_assignments

5641: and dh.disb_header_id >= c_disb_hdr_id;
5642: */
5643: CURSOR get_instal_num(p_loan_id number, p_disb_header_id NUMBER) IS
5644: select begin_installment_number
5645: from lns_fee_assignments
5646: where loan_id = p_loan_id
5647: and disb_header_id = p_disb_header_id;
5648:
5649: BEGIN