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_BILLING_BATCH_PUB dependencies on LNS_DISB_HEADERS

Line 3251: 'from lns_disb_headers head, ' ||

3247: 'to_char(head.HEADER_AMOUNT, :CURRENCY_FORMAT18) f_header_amount, ' ||
3248: 'fnd_date.date_to_chardate((select max(DISBURSEMENT_DATE) from lns_disb_lines where DISB_HEADER_ID = head.DISB_HEADER_ID)) DISBURSEMENT_DATE, ' ||
3249: 'fund_status.meaning status, ' ||
3250: 'fund_act.meaning activity_name ' ||
3251: 'from lns_disb_headers head, ' ||
3252: 'lns_lookups fund_status, ' ||
3253: 'lns_lookups fund_act ' ||
3254: 'where head.loan_id = loan.loan_id and ' ||
3255: 'fund_status.lookup_type(+) = ''FUNDING_STATUS'' and ' ||

Line 3558: OR disb_header_id in (select disb_header_id from lns_disb_headers where loan_id = P_LOAN_ID)

3554: and billing_option = 'ORIGINATION'
3555: and (loan_id = P_LOAN_ID
3556: -- Bug#6961250, The loanId is NULL if for the disbFees in lns_fee_assignments.
3557: -- So to check any existed 0th installment fees for a loan, also check existed fees for disb_header_id.
3558: OR disb_header_id in (select disb_header_id from lns_disb_headers where loan_id = P_LOAN_ID)
3559: );
3560: /* get statement after its billed */
3561: CURSOR get_statement_cur(P_LOAN_ID number) IS
3562: select STATEMENT_XML