APPS.LNS_REP_UTILS dependencies on JTF_RS_RESOURCE_EXTNS

Line 238: l_loan_officer jtf_rs_resource_extns.source_name%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;
241: l_include_charts VARCHAR2(30);
242: l_close_tag VARCHAR2(100);

Line 480: FROM jtf_rs_resource_extns

476: IF loan_assigned_to is NOT NULL
477: THEN
478: SELECT source_name
479: INTO l_loan_officer
480: FROM jtf_rs_resource_extns
481: WHERE resource_id = loan_assigned_to;
482: END IF;
483: ctx := DBMS_XMLQUERY.newContext(l_query);
484: LogMessage(FND_LOG.LEVEL_STATEMENT, 'after DBMS_XMLQUERY.newContext');

Line 640: l_loan_officer jtf_rs_resource_extns.source_name%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);
644: l_query VARCHAR2(11000) :=

Line 956: FROM jtf_rs_resource_extns

952: IF loan_assigned_to is NOT NULL
953: THEN
954: SELECT source_name
955: INTO l_loan_officer
956: FROM jtf_rs_resource_extns
957: WHERE resource_id = loan_assigned_to;
958: END IF;
959: ctx := DBMS_XMLQUERY.newContext(l_query);
960: DBMS_XMLQuery.setRaiseNoRowsException(ctx,TRUE);

Line 1654: jtf_rs_resource_extns res,

1650: lns_lookups llkdc,
1651: lns_lookups llkfq,
1652: lns_lookups llkfqf,
1653: lns_lookups llkic,
1654: jtf_rs_resource_extns res,
1655: lns_disb_headers ldh,
1656: lns_loan_products_all_vl product
1657: where
1658: lh.primary_borrower_id = hp.party_id and