APPS.LNS_FUNDING_PUB dependencies on LNS_LOAN_PRODUCTS_ALL

Line 7648: from lns_loan_products_all prod,

7644:
7645: -- querying required approval flag
7646: CURSOR appr_flag_cur(P_LOAN_ID number) IS
7647: select nvl(prod.APPR_REQ_FOR_CNCL_FLAG, 'N')
7648: from lns_loan_products_all prod,
7649: lns_loan_headers_all loan
7650: where loan.loan_id = P_LOAN_ID and
7651: loan.product_id = prod.loan_product_id;
7652: BEGIN