APPS.LNS_REP_UTILS dependencies on JTF_RS_RESOURCE_EXTNS

Line 212: l_loan_officer jtf_rs_resource_extns.source_name%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;
213: l_loan_status1_desc lns_lookups.meaning%TYPE;
214: l_loan_status2_desc lns_lookups.meaning%TYPE;
215: l_include_charts VARCHAR2(30);
216: l_close_tag VARCHAR2(100);

Line 429: FROM jtf_rs_resource_extns

425: IF loan_assigned_to is NOT NULL
426: THEN
427: SELECT source_name
428: INTO l_loan_officer
429: FROM jtf_rs_resource_extns
430: WHERE resource_id = loan_assigned_to;
431: END IF;
432: ctx := DBMS_XMLQUERY.newContext(l_query);
433: -- Bind Mandatory Variables

Line 577: l_loan_officer jtf_rs_resource_extns.source_name%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;
579: l_loan_status2_desc lns_lookups.meaning%TYPE;
580: l_close_tag VARCHAR2(100);
581: l_query VARCHAR2(11000) :=

Line 893: FROM jtf_rs_resource_extns

889: IF loan_assigned_to is NOT NULL
890: THEN
891: SELECT source_name
892: INTO l_loan_officer
893: FROM jtf_rs_resource_extns
894: WHERE resource_id = loan_assigned_to;
895: END IF;
896: ctx := DBMS_XMLQUERY.newContext(l_query);
897: DBMS_XMLQuery.setRaiseNoRowsException(ctx,TRUE);

Line 1550: jtf_rs_resource_extns res,

1546: lns_lookups llkdc,
1547: lns_lookups llkfq,
1548: lns_lookups llkfqf,
1549: lns_lookups llkic,
1550: jtf_rs_resource_extns res,
1551: lns_disb_headers ldh,
1552: lns_loan_products_all_vl product
1553: where
1554: lh.primary_borrower_id = hp.party_id and