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 7461: from lns_loan_histories_h

7457:
7458: -- getting loan previous status
7459: CURSOR prev_status_cur(P_LOAN_ID number) IS
7460: select old_value
7461: from lns_loan_histories_h
7462: where table_name = 'LNS_LOAN_HEADERS_ALL' and
7463: column_name = 'LOAN_STATUS' and
7464: new_value = 'PENDING_CANCELLATION' and
7465: loan_id = P_LOAN_ID and

Line 7468: from lns_loan_histories_h

7464: new_value = 'PENDING_CANCELLATION' and
7465: loan_id = P_LOAN_ID and
7466: loan_history_id =
7467: (select max(loan_history_id)
7468: from lns_loan_histories_h
7469: where table_name = 'LNS_LOAN_HEADERS_ALL' and
7470: column_name = 'LOAN_STATUS' and
7471: loan_id = P_LOAN_ID);
7472: