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_UTIL_PUB dependencies on LNS_LOAN_HEADERS_ALL

Line 285: ,lns_loan_headers_all loan

281: SELECT nvl(count(1),0)
282: INTO l_zero_inst_count
283: FROM lns_fee_schedules schd
284: ,lns_fees_all struct
285: ,lns_loan_headers_all loan
286: WHERE loan.loan_id = P_LOAN_ID
287: AND schd.loan_id = loan.loan_id
288: AND schd.fee_id = struct.fee_id
289: AND struct.fee_type = 'EVENT_ORIGINATION'

Line 979: from lns_loan_headers_all loan

975: rec.org_id = loan.org_id and
976: am.loan_id = loan.loan_id and
977: am.principal_trx_id is not null and
978: nvl(am.PHASE, 'TERM') = nvl(loan.CURRENT_PHASE, 'TERM'))
979: from lns_loan_headers_all loan
980: where loan.loan_id = P_LOAN_ID;
981:
982: BEGIN
983: OPEN get_data_crs(P_LOAN_ID, P_DATE);

Line 1056: FROM LNS_LOAN_HEADERS_ALL LnsLoanHeaderEO

1052: and (am.REVERSED_FLAG is null or am.REVERSED_FLAG = 'N')
1053: and am.REAMORTIZATION_AMOUNT is null
1054: and psa_prin.customer_trx_id = am.principal_trx_id)
1055: END)
1056: FROM LNS_LOAN_HEADERS_ALL LnsLoanHeaderEO
1057: WHERE loan_id = P_LOAN_ID;
1058: */
1059:
1060: BEGIN