APPS.AR_CMGT_WF_ENGINE dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 408: jtf_rs_resource_extns_vl c

404: CURSOR c_get_resource_id IS
405: SELECT c.resource_id, c.source_id --employee id
406: FROM jtf_rs_role_relations a,
407: jtf_rs_roles_vl b,
408: jtf_rs_resource_extns_vl c
409: WHERE a.role_resource_type = 'RS_INDIVIDUAL'
410: AND a.role_resource_id = c.resource_id
411: AND a.role_id = b.role_id
412: AND b.role_code = 'CREDIT_ANALYST'

Line 468: l_resource_id jtf_rs_resource_extns_vl.resource_id%type;

464: funcmode in varchar2,
465: resultout out NOCOPY varchar2) IS
466:
467: l_employee_id fnd_user.employee_id%type;
468: l_resource_id jtf_rs_resource_extns_vl.resource_id%type;
469: l_notification_id NUMBER;
470: l_user_name VARCHAR2(60);
471: l_display_name VARCHAR2(240);
472: l_failure_function VARCHAR2(60);

Line 499: jtf_rs_resource_extns_vl c

495: SELECT c.resource_id
496: INTO l_resource_id
497: FROM jtf_rs_role_relations a,
498: jtf_rs_roles_vl b,
499: jtf_rs_resource_extns_vl c
500: WHERE a.role_resource_type = 'RS_INDIVIDUAL'
501: AND a.role_resource_id = c.resource_id
502: AND a.role_id = b.role_id
503: AND b.role_code = 'CREDIT_ANALYST'

Line 928: jtf_rs_resource_extns_vl c

924: SELECT 'X'
925: INTO l_dummy
926: FROM jtf_rs_role_relations a,
927: jtf_rs_roles_vl b,
928: jtf_rs_resource_extns_vl c
929: WHERE a.role_resource_type = 'RS_INDIVIDUAL'
930: AND a.role_resource_id = c.resource_id
931: AND c.resource_id = l_credit_analyst_id
932: AND a.role_id = b.role_id

Line 955: FROM jtf_rs_resource_extns_vl

951: END IF;
952: BEGIN
953: SELECT source_id
954: INTO l_employee_id
955: FROM jtf_rs_resource_extns_vl
956: WHERE resource_id = l_credit_analyst_id
957: AND category = 'EMPLOYEE';
958:
959: EXCEPTION