APPS.PA_HR_RESOURCE dependencies on PA_RESOURCE_LIST_MEMBERS

Line 22: /* Bug#2738741 - Added this new cursor resource_list_ref for checking in pa_resource_list_members

18: select resource_id /* Bug 2738741 - Changed from null to resource_id */
19: from PA_RESOURCE_TXN_ATTRIBUTES pa
20: where pa.person_id = P_PERSON_ID;
21:
22: /* Bug#2738741 - Added this new cursor resource_list_ref for checking in pa_resource_list_members
23: which stores the members of a resource list */
24:
25: CURSOR resource_list_ref(p_resource_id number) IS
26: SELECT 'x' FROM pa_resource_list_members

Line 26: SELECT 'x' FROM pa_resource_list_members

22: /* Bug#2738741 - Added this new cursor resource_list_ref for checking in pa_resource_list_members
23: which stores the members of a resource list */
24:
25: CURSOR resource_list_ref(p_resource_id number) IS
26: SELECT 'x' FROM pa_resource_list_members
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

Line 47: /* Bug#2738741 - Modified the code here to check in cursor pa_resource_list_members

43: END IF;
44: CLOSE rbs_person_ref;
45:
46:
47: /* Bug#2738741 - Modified the code here to check in cursor pa_resource_list_members
48: and raise error if records in the cursor. If not delete records from pa_resources_denorm,
49: pa_resource_txn_attributes, pa_resources */
50:
51: Error_Message := 'PA_HR_PER_RES_TXN_ATTR';

Line 122: WHERE exists (select 'Y' from pa_resource_list_members

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
126: where job_id = p_job_id);