APPS.PA_HR_RESOURCE dependencies on DUAL

Line 121: FROM dual

117: where pa.job_id = P_JOB_ID;
118:
119: cursor chk_plan_res_rbs(p_job_id IN NUMBER) IS
120: SELECT 'Y'
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