APPS.LNS_WORK_FLOW dependencies on JTF_RS_RESOURCE_EXTNS

Line 955: l_loan_assigned_name jtf_rs_resource_extns.source_name%TYPE;

951: l_primary_recipient_name lns_event_actions.primary_recipient_name%TYPE;
952: l_priority_num lns_event_actions.priority_num%TYPE;
953: l_active_for_num lns_event_actions.active_for_num%TYPE;
954: l_delivery_method lns_event_actions.delivery_method%TYPE;
955: l_loan_assigned_name jtf_rs_resource_extns.source_name%TYPE;
956: l_loan_assigned_user fnd_user.user_name%TYPE;
957: l_current_user fnd_user.user_name%TYPE;
958: l_borrower_name hz_parties.party_name%TYPE;
959: l_loan_class lns_lookups.meaning%TYPE;

Line 1008: ,jtf_rs_resource_extns res

1004: SELECT fndu.user_name
1005: ,fndu.user_id
1006: FROM jtf_rs_role_relations rel
1007: ,jtf_rs_roles_b rol
1008: ,jtf_rs_resource_extns res
1009: ,fnd_user fndu
1010: WHERE rel.role_id = rol.role_id
1011: AND rel.delete_flag <> 'Y'
1012: AND SYSDATE BETWEEN NVL(rel.start_date_active,sysdate)

Line 1039: jtf_rs_resource_extns res, fnd_user fnd,

1035: ,llkp.meaning loan_purpose
1036: ,llh.org_id
1037: ,lprod.loan_product_name
1038: FROM lns_loan_headers_all_vl llh, hz_parties hp,
1039: jtf_rs_resource_extns res, fnd_user fnd,
1040: lns_payments_summary_v ps,
1041: lns_lookups llktt,
1042: lns_lookups llklc,
1043: lns_loan_types_vl llklt,

Line 3020: jtf_rs_resource_extns res

3016: and rol.role_type_code = 'LOANS'
3017: and rol.role_code = 'LOAN_MGR'
3018: and rol.active_flag = 'Y'
3019: ) manager,
3020: jtf_rs_resource_extns res
3021: where
3022: manager.role_resource_id(+) = res.resource_id
3023: and category = 'EMPLOYEE'
3024: and res.start_date_active <= sysdate