eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_REP_UTILS dependencies on XLE_ENTITY_PROFILES

Line 235: l_legal_entity_id xle_entity_profiles.legal_entity_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;
239: l_loan_status1_desc lns_lookups.meaning%TYPE;

Line 236: l_legal_entity_name xle_entity_profiles.name%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;
239: l_loan_status1_desc lns_lookups.meaning%TYPE;
240: l_loan_status2_desc lns_lookups.meaning%TYPE;

Line 466: FROM xle_entity_profiles

462: IF legal_entity_id is NOT NULL
463: THEN
464: SELECT NAME
465: INTO l_legal_entity_name
466: FROM xle_entity_profiles
467: WHERE legal_entity_id = l_legal_entity_id;
468: END IF;
469: IF product_id is NOT NULL
470: THEN

Line 638: l_legal_entity_id xle_entity_profiles.legal_entity_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;
642: l_loan_status2_desc lns_lookups.meaning%TYPE;

Line 639: l_legal_entity_name xle_entity_profiles.name%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;
642: l_loan_status2_desc lns_lookups.meaning%TYPE;
643: l_close_tag VARCHAR2(100);

Line 853: 'xle_entity_profiles le, ' ||

849: 'fnd_territories_vl terr, ' ||
850: 'hz_party_sites site, ' ||
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 ' ||

Line 949: FROM xle_entity_profiles

945: IF legal_entity_id is NOT NULL
946: THEN
947: SELECT NAME
948: INTO l_legal_entity_name
949: FROM xle_entity_profiles
950: WHERE legal_entity_id = l_legal_entity_id;
951: END IF;
952: IF loan_assigned_to is NOT NULL
953: THEN