APPS.LNS_REP_UTILS dependencies on LNS_LOAN_TYPES

Line 233: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;

229: l_account_number hz_cust_accounts.account_number%TYPE;
230: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
231: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
232: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
233: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
234: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
235: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
236: l_legal_entity_name xle_entity_profiles.name%TYPE;
237: l_loan_product_name lns_loan_products_all.loan_product_name%TYPE;

Line 234: l_loan_type_id lns_loan_types.loan_type_id%TYPE;

230: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
231: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
232: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
233: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
234: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
235: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
236: l_legal_entity_name xle_entity_profiles.name%TYPE;
237: l_loan_product_name lns_loan_products_all.loan_product_name%TYPE;
238: l_loan_officer jtf_rs_resource_extns.source_name%TYPE;

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 636: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;

632: l_account_number hz_cust_accounts.account_number%TYPE;
633: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
634: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
635: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
636: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
637: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
638: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
639: l_legal_entity_name xle_entity_profiles.name%TYPE;
640: l_loan_officer jtf_rs_resource_extns.source_name%TYPE;

Line 637: l_loan_type_id lns_loan_types.loan_type_id%TYPE;

633: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
634: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
635: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
636: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
637: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
638: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
639: l_legal_entity_name xle_entity_profiles.name%TYPE;
640: l_loan_officer jtf_rs_resource_extns.source_name%TYPE;
641: l_loan_status1_desc lns_lookups.meaning%TYPE;

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,