APPS.AR_CMGT_UTIL dependencies on JTF_RS_ROLES_VL

Line 114: jtf_rs_roles_vl b,

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
118: AND b.role_type_code = 'CREDIT_MGMT'

Line 193: jtf_rs_roles_vl b,

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
197: AND b.role_type_code = 'CREDIT_MGMT'

Line 274: jtf_rs_roles_vl b,

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
278: AND a.role_id = b.role_id

Line 302: jtf_rs_roles_vl b,

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
306: AND a.role_id = b.role_id

Line 351: jtf_rs_roles_vl b,

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
355: AND a.role_id = b.role_id

Line 375: JTF_RS_ROLES_VL role_vl,

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'
379: and role_vl.role_id = rel.role_id