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_HEADERS

Line 476: FROM LNS_LOAN_HEADERS_ALL H,

472: ,NVL(P.BDGT_REQ_FOR_APPR_FLAG, 'N') BDGT_REQ_FOR_APPR_FLAG
473: ,NVL(P.LOAN_APPR_REQ_FLAG, 'Y') LOAN_APPR_REQ_FLAG
474: ,H.SECONDARY_STATUS
475: ,nvl(custom_payments_flag, 'N')
476: FROM LNS_LOAN_HEADERS_ALL H,
477: LNS_LOAN_PRODUCTS_ALL P
478: WHERE H.LOAN_ID = X_Loan_Id
479: and H.product_id = P.loan_product_id(+);
480:

Line 512: from LNS_LOAN_HEADERS

508: where LOAN_ID = P_LOAN_ID;
509:
510: CURSOR loan_version_cur(P_LOAN_ID number) IS
511: select OBJECT_VERSION_NUMBER
512: from LNS_LOAN_HEADERS
513: where LOAN_ID = P_LOAN_ID;
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

Line 519: where table_name = 'LNS_LOAN_HEADERS_ALL' and

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
523: loan_history_id =

Line 526: where table_name = 'LNS_LOAN_HEADERS_ALL' 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:
530: BEGIN