APPS.LNS_REP_UTILS dependencies on LNS_LOAN_TYPES

Line 207: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;

203: l_account_number hz_cust_accounts.account_number%TYPE;
204: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
205: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
206: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
207: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
208: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
209: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
210: l_legal_entity_name xle_entity_profiles.name%TYPE;
211: l_loan_product_name lns_loan_products_all.loan_product_name%TYPE;

Line 208: l_loan_type_id lns_loan_types.loan_type_id%TYPE;

204: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
205: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
206: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
207: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
208: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
209: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
210: l_legal_entity_name xle_entity_profiles.name%TYPE;
211: l_loan_product_name lns_loan_products_all.loan_product_name%TYPE;
212: l_loan_officer jtf_rs_resource_extns.source_name%TYPE;

Line 319: from lns_loan_types_vl

315: END IF;
316: BEGIN
317: SELECT loan_type_desc
318: into l_loan_type_desc
319: from lns_loan_types_vl
320: where loan_type_id = l_loan_type_id;
321: EXCEPTION
322: WHEN NO_DATA_FOUND THEN null;
323: END;

Line 573: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;

569: l_account_number hz_cust_accounts.account_number%TYPE;
570: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
571: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
572: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
573: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
574: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
575: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
576: l_legal_entity_name xle_entity_profiles.name%TYPE;
577: l_loan_officer jtf_rs_resource_extns.source_name%TYPE;

Line 574: l_loan_type_id lns_loan_types.loan_type_id%TYPE;

570: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
571: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
572: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
573: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
574: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
575: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
576: l_legal_entity_name xle_entity_profiles.name%TYPE;
577: l_loan_officer jtf_rs_resource_extns.source_name%TYPE;
578: l_loan_status1_desc lns_lookups.meaning%TYPE;

Line 792: 'lns_loan_types_vl lot ' ||

788: 'hz_cust_acct_sites_all acct_site, ' ||
789: 'lns_loan_products_vl product, ' ||
790: 'xle_entity_profiles le, ' ||
791: 'hr_operating_units ou, ' ||
792: 'lns_loan_types_vl lot ' ||
793: 'where ' ||
794: 'lh.primary_borrower_id = hp.party_id and ' ||
795: 'lh.loan_id = pay.loan_id and ' ||
796: 'llk.lookup_code = lh.loan_status and ' ||

Line 832: from lns_loan_types_vl

828: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID();
829: BEGIN
830: SELECT loan_type_desc
831: into l_loan_type_desc
832: from lns_loan_types_vl
833: where loan_type_id = l_loan_type_id;
834: EXCEPTION
835: WHEN NO_DATA_FOUND THEN null;
836: END;

Line 1542: lns_loan_types_vl llt,

1538: --LNS_PAY_SUM_V pay, --Bug5262505
1539: xle_firstparty_information_v xle,
1540: lns_lookups llkrt,
1541: lns_lookups llktt,
1542: lns_loan_types_vl llt,
1543: lns_lookups llklc,
1544: lns_lookups llkp,
1545: lns_lookups llkst,
1546: lns_lookups llkdc,