APPS.LNS_WORK_FLOW dependencies on JTF_RS_RESOURCE_EXTNS

Line 665: l_loan_assigned_name jtf_rs_resource_extns.source_name%TYPE;

661: l_primary_recipient_name lns_event_actions.primary_recipient_name%TYPE;
662: l_priority_num lns_event_actions.priority_num%TYPE;
663: l_active_for_num lns_event_actions.active_for_num%TYPE;
664: l_delivery_method lns_event_actions.delivery_method%TYPE;
665: l_loan_assigned_name jtf_rs_resource_extns.source_name%TYPE;
666: l_loan_assigned_user fnd_user.user_name%TYPE;
667: l_current_user fnd_user.user_name%TYPE;
668: l_borrower_name hz_parties.party_name%TYPE;
669: l_loan_class lns_lookups.meaning%TYPE;

Line 714: ,jtf_rs_resource_extns res

710: SELECT fndu.user_name
711: ,fndu.user_id
712: FROM jtf_rs_role_relations rel
713: ,jtf_rs_roles_b rol
714: ,jtf_rs_resource_extns res
715: ,fnd_user fndu
716: WHERE rel.role_id = rol.role_id
717: AND rel.delete_flag <> 'Y'
718: AND SYSDATE BETWEEN NVL(rel.start_date_active,sysdate)

Line 743: jtf_rs_resource_extns res, fnd_user fnd,

739: ,LNS_FINANCIALS.getActiveRate(llh.LOAN_ID) interest_rate
740: ,llkp.meaning loan_purpose
741: ,llh.org_id
742: FROM lns_loan_headers_all_vl llh, hz_parties hp,
743: jtf_rs_resource_extns res, fnd_user fnd,
744: lns_payments_summary_v ps,
745: lns_lookups llktt,
746: lns_lookups llklc,
747: lns_loan_types_vl llklt,