APPS.PA_HR_RESOURCE dependencies on PA_RBS_ELEMENTS

Line 31: SELECT 'x' FROM pa_rbs_elements

27: WHERE resource_id = p_resource_id;
28:
29: -- Bug 4116995 - check if person used in RBS
30: CURSOR rbs_person_ref(p_person_id number) IS
31: SELECT 'x' FROM pa_rbs_elements
32: WHERE person_id = p_person_id;
33:
34: BEGIN
35:

Line 125: select 'Y' from pa_rbs_elements

121: FROM dual
122: WHERE exists (select 'Y' from pa_resource_list_members
123: where job_id = p_job_id
124: UNION
125: select 'Y' from pa_rbs_elements
126: where job_id = p_job_id);
127:
128: BEGIN
129: /* Bug no.2432494: error message below was changed from PA_HR_JOB_RSRC_TRN_ATTR