DBA Data[Home] [Help]

APPS.LNS_REP_UTILS dependencies on LNS_LOAN_TYPES_VL

Line 367: from lns_loan_types_vl

363:
364: BEGIN
365: SELECT loan_type_desc
366: into l_loan_type_desc
367: from lns_loan_types_vl
368: where loan_type_id = l_loan_type_id;
369: EXCEPTION
370: WHEN NO_DATA_FOUND THEN null;
371: END;

Line 855: 'lns_loan_types_vl lot ' ||

851: 'hz_cust_acct_sites_all acct_site, ' ||
852: 'lns_loan_products_vl product, ' ||
853: 'xle_entity_profiles le, ' ||
854: 'hr_operating_units ou, ' ||
855: 'lns_loan_types_vl lot ' ||
856: 'where ' ||
857: 'lh.primary_borrower_id = hp.party_id and ' ||
858: 'lh.loan_id = pay.loan_id and ' ||
859: 'llk.lookup_code = lh.loan_status and ' ||

Line 895: from lns_loan_types_vl

891: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID();
892: BEGIN
893: SELECT loan_type_desc
894: into l_loan_type_desc
895: from lns_loan_types_vl
896: where loan_type_id = l_loan_type_id;
897: EXCEPTION
898: WHEN NO_DATA_FOUND THEN null;
899: END;

Line 1646: lns_loan_types_vl llt,

1642: --LNS_PAY_SUM_V pay, --Bug5262505
1643: xle_firstparty_information_v xle,
1644: lns_lookups llkrt,
1645: lns_lookups llktt,
1646: lns_loan_types_vl llt,
1647: lns_lookups llklc,
1648: lns_lookups llkp,
1649: lns_lookups llkst,
1650: lns_lookups llkdc,