APPS.LNS_APPROVAL_ACTION_PUB dependencies on LNS_LOAN_PRODUCTS_ALL

Line 485: LNS_LOAN_PRODUCTS_ALL P

481: ,NVL(P.LOAN_APPR_REQ_FLAG, 'Y') LOAN_APPR_REQ_FLAG
482: ,H.SECONDARY_STATUS
483: ,nvl(custom_payments_flag, 'N')
484: FROM LNS_LOAN_HEADERS_ALL H,
485: LNS_LOAN_PRODUCTS_ALL P
486: WHERE H.LOAN_ID = X_Loan_Id
487: and H.product_id = P.loan_product_id(+);
488:
489: CURSOR C_Get_Resource_Id (X_User_Id NUMBER) IS