APPS.AR_CMGT_WF_ENGINE dependencies on JTF_RS_ROLE_RELATIONS

Line 406: FROM jtf_rs_role_relations a,

402: l_display_name per_people_f.full_name%type;
403:
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

Line 497: FROM jtf_rs_role_relations a,

493: END;
494: BEGIN
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

Line 926: FROM jtf_rs_role_relations a,

922:
923: BEGIN
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