APPS.PA_GET_RESOURCE dependencies on PA_PROJECT_ACCUM_HEADERS

Line 1090: -- for a resource member . It is using pa_project_accum_headers

1086:
1087:
1088: FUNCTION Child_resource_exists
1089: -- This function checks existence of child level resource member
1090: -- for a resource member . It is using pa_project_accum_headers
1091: -- to ensure that for the specified project and task that resource
1092: -- was used for accumulation .This is done because this function is
1093: -- called from project status inquiry
1094: (p_resource_id number ,

Line 1106: exists ( select 1 from pa_resource_list_members p,pa_project_accum_headers h

1102: begin
1103: select 1
1104: into temp
1105: from sys.dual where
1106: exists ( select 1 from pa_resource_list_members p,pa_project_accum_headers h
1107: where p.resource_list_member_id = h.resource_list_member_id
1108: and p.parent_member_id = p_resource_id
1109: and h.project_id = p_project_id
1110: and h.task_id = p_task_id );

Line 1287: from pa_resource_list_assignments rla, pa_project_accum_headers pah

1283: SELECT 'x'
1284: FROM dual
1285: WHERE exists
1286: (select 'x'
1287: from pa_resource_list_assignments rla, pa_project_accum_headers pah
1288: where rla.resource_list_id = l_resource_list_id
1289: and rla.project_id = pah.project_id
1290: and rla.resource_list_id = pah.resource_list_id
1291: and pah.resource_list_member_id = l_resource_list_member_id);