DBA Data[Home] [Help]

APPS.AR_CMGT_WF_ENGINE dependencies on JTF_RS_ROLE_RELATIONS

Line 385: FROM jtf_rs_role_relations a,

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

Line 476: FROM jtf_rs_role_relations a,

472: END;
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

Line 761: FROM jtf_rs_role_relations a,

757:
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