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

514:
515: -- getting loan previous secondary status to reset if Conversion request is rejected
516: CURSOR prev_sec_status_cur(P_LOAN_ID number) IS
517: select old_value
518: from lns_loan_histories_h
519: where table_name = 'LNS_LOAN_HEADERS_ALL' and
520: column_name = 'SECONDARY_STATUS' and
521: new_value = 'PENDING_CANCELLATION' and
522: loan_id = P_LOAN_ID and

Line 525: from lns_loan_histories_h

521: new_value = 'PENDING_CANCELLATION' and
522: loan_id = P_LOAN_ID and
523: loan_history_id =
524: (select max(loan_history_id)
525: from lns_loan_histories_h
526: where table_name = 'LNS_LOAN_HEADERS_ALL' and
527: column_name = 'SECONDARY_STATUS' and
528: loan_id = P_LOAN_ID);
529: