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_DISTRIBUTIONS_PUB dependencies on LNS_LOAN_TYPES

Line 845: ,lns_loan_types t

841: select h.loan_class_code
842: ,t.loan_type_id
843: ,h.funded_amount
844: from lns_loan_headers_all h
845: ,lns_loan_types t
846: where h.loan_id = p_loan_id
847: and h.loan_type_id = t.loan_type_id;
848:
849: cursor c_loan_info2(p_loan_id NUMBER, p_disb_header_id number)

Line 855: ,lns_loan_types t

851: select h.loan_class_code
852: ,t.loan_type_id
853: ,d.header_amount
854: from lns_loan_headers_all h
855: ,lns_loan_types t
856: ,lns_disb_headers d
857: where h.loan_id = p_loan_id
858: and h.loan_type_id = t.loan_type_id
859: and h.loan_id = d.loan_id

Line 3405: ,lns_loan_types t

3401: ,t.loan_type_id
3402: ,h.funded_amount
3403: ,h.legal_entity_id
3404: from lns_loan_headers_all h
3405: ,lns_loan_types t
3406: where h.loan_id = p_loan_id
3407: and h.loan_type_id = t.loan_type_id;
3408:
3409: -- use this to get all adjustments to be processed for the loan