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_APPROVAL_ACTION_PUB dependencies on LNS_LOAN_HISTORIES_H

Line 526: from lns_loan_histories_h

522:
523: -- getting loan previous secondary status to reset if Conversion request is rejected
524: CURSOR prev_sec_status_cur(P_LOAN_ID number) IS
525: select old_value
526: from lns_loan_histories_h
527: where table_name = 'LNS_LOAN_HEADERS_ALL' and
528: column_name = 'SECONDARY_STATUS' and
529: new_value = 'PENDING_CANCELLATION' and
530: loan_id = P_LOAN_ID and

Line 533: from lns_loan_histories_h

529: new_value = 'PENDING_CANCELLATION' and
530: loan_id = P_LOAN_ID and
531: loan_history_id =
532: (select max(loan_history_id)
533: from lns_loan_histories_h
534: where table_name = 'LNS_LOAN_HEADERS_ALL' and
535: column_name = 'SECONDARY_STATUS' and
536: loan_id = P_LOAN_ID);
537: