DBA Data[Home] [Help]

APPS.LNS_LOAN_LINE_PUB dependencies on LNS_LOAN_PRODUCTS_ALL_VL

Line 256: from lns_loan_products_all_vl

252: (select null from lns_loan_lines where loan_id = pLoanId and end_date is null);
253:
254: CURSOR c_loan_product(pLoanProductId Number, pOrgId Number) IS
255: select loan_product_name,MAX_REQUESTED_AMOUNT
256: from lns_loan_products_all_vl
257: where loan_product_id = pLoanProductId
258: and org_id = pOrgId;
259:
260: --Need to define separate table types for each column for bulk insert since table type with all columns is not supported for bulk processing