APPS.LNS_APPROVAL_ACTION_PUB dependencies on LNS_LOAN_PRODUCTS_ALL

Line 477: LNS_LOAN_PRODUCTS_ALL P

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:
481: CURSOR C_Get_Resource_Id (X_User_Id NUMBER) IS