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