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_LOAN_HISTORIES_H

Line 6980: from lns_loan_histories_h

6976:
6977: -- getting loan previous status
6978: CURSOR prev_status_cur(P_LOAN_ID number) IS
6979: select old_value
6980: from lns_loan_histories_h
6981: where table_name = 'LNS_LOAN_HEADERS_ALL' and
6982: column_name = 'LOAN_STATUS' and
6983: new_value = 'PENDING_CANCELLATION' and
6984: loan_id = P_LOAN_ID and

Line 6987: from lns_loan_histories_h

6983: new_value = 'PENDING_CANCELLATION' and
6984: loan_id = P_LOAN_ID and
6985: loan_history_id =
6986: (select max(loan_history_id)
6987: from lns_loan_histories_h
6988: where table_name = 'LNS_LOAN_HEADERS_ALL' and
6989: column_name = 'LOAN_STATUS' and
6990: loan_id = P_LOAN_ID);
6991: