APPS.AR_CMGT_WF_ENGINE dependencies on JTF_RS_ROLES_VL

Line 386: jtf_rs_roles_vl b,

382:
383: CURSOR c_get_resource_id IS
384: SELECT c.resource_id, c.source_id --employee id
385: FROM jtf_rs_role_relations a,
386: jtf_rs_roles_vl b,
387: jtf_rs_resource_extns_vl c
388: WHERE a.role_resource_type = 'RS_INDIVIDUAL'
389: AND a.role_resource_id = c.resource_id
390: AND a.role_id = b.role_id

Line 477: jtf_rs_roles_vl b,

473: BEGIN
474: SELECT c.resource_id
475: INTO l_resource_id
476: FROM jtf_rs_role_relations a,
477: jtf_rs_roles_vl b,
478: jtf_rs_resource_extns_vl c
479: WHERE a.role_resource_type = 'RS_INDIVIDUAL'
480: AND a.role_resource_id = c.resource_id
481: AND a.role_id = b.role_id

Line 762: jtf_rs_roles_vl b,

758: BEGIN
759: SELECT 'X'
760: INTO l_dummy
761: FROM jtf_rs_role_relations a,
762: jtf_rs_roles_vl b,
763: jtf_rs_resource_extns_vl c
764: WHERE a.role_resource_type = 'RS_INDIVIDUAL'
765: AND a.role_resource_id = c.resource_id
766: AND c.resource_id = l_credit_analyst_id