APPS.AR_CMGT_UTIL dependencies on JTF_RS_ROLE_RELATIONS

Line 113: FROM jtf_rs_role_relations a,

109: l_resource_id NUMBER;
110:
111: CURSOR get_resource_analyst IS
112: SELECT c.resource_id
113: FROM jtf_rs_role_relations a,
114: jtf_rs_roles_vl b,
115: jtf_rs_resource_extns c
116: WHERE a.role_resource_type = 'RS_INDIVIDUAL'
117: AND a.role_resource_id = c.resource_id

Line 192: FROM jtf_rs_role_relations a,

188: l_resource_id NUMBER;
189:
190: CURSOR get_resource_analyst IS
191: SELECT c.resource_id
192: FROM jtf_rs_role_relations a,
193: jtf_rs_roles_vl b,
194: jtf_rs_resource_extns c
195: WHERE a.role_resource_type = 'RS_INDIVIDUAL'
196: AND a.role_resource_id = c.resource_id

Line 273: FROM jtf_rs_role_relations a,

269:
270: BEGIN
271: SELECT 'Y'
272: INTO l_credit_analyst
273: FROM jtf_rs_role_relations a,
274: jtf_rs_roles_vl b,
275: jtf_rs_resource_extns c
276: WHERE a.role_resource_type = 'RS_INDIVIDUAL'
277: AND a.role_resource_id = c.resource_id

Line 301: FROM jtf_rs_role_relations a,

297:
298: BEGIN
299: SELECT 'Y'
300: INTO l_credit_analyst
301: FROM jtf_rs_role_relations a,
302: jtf_rs_roles_vl b,
303: jtf_rs_resource_extns c
304: WHERE a.role_resource_type = 'RS_INDIVIDUAL'
305: AND a.role_resource_id = c.resource_id

Line 350: FROM jtf_rs_role_relations a,

346:
347: BEGIN
348: SELECT 'Y'
349: INTO l_credit_analyst
350: FROM jtf_rs_role_relations a,
351: jtf_rs_roles_vl b,
352: jtf_rs_resource_extns c
353: WHERE a.role_resource_type = 'RS_INDIVIDUAL'
354: AND a.role_resource_id = c.resource_id

Line 374: JTF_RS_ROLE_RELATIONS rel,

370:
371: CURSOR credit_analyst_name(p_resource_id IN NUMBER) IS
372: SELECT per.FULL_NAME
373: FROM JTF_RS_RESOURCE_EXTNS rextns,
374: JTF_RS_ROLE_RELATIONS rel,
375: JTF_RS_ROLES_VL role_vl,
376: PER_ALL_PEOPLE_F per
377: WHERE role_vl.role_type_code = 'CREDIT_MGMT'
378: and role_vl.role_code = 'CREDIT_ANALYST'