APPS.PA_SCHEDULE_UTILS dependencies on PA_RESOURCES_DENORM

Line 830: from pa_resources_denorm

826: -- Get resource's organization on their
827: -- min(resource_effective_start_date)
828: select resource_organization_id
829: into l_resource_organization_id
830: from pa_resources_denorm
831: where resource_effective_start_date =
832: (select min(res1.resource_effective_start_date)
833: from pa_resources_denorm res1
834: where res1.resource_id = p_resource_id)

Line 833: from pa_resources_denorm res1

829: into l_resource_organization_id
830: from pa_resources_denorm
831: where resource_effective_start_date =
832: (select min(res1.resource_effective_start_date)
833: from pa_resources_denorm res1
834: where res1.resource_id = p_resource_id)
835: and resource_id = p_resource_id;
836:
837: -- Get default calendar using organization id.

Line 917: FROM PA_RESOURCES_DENORM

913:
914: IF p_person_id IS NOT NULL THEN
915: SELECT resource_id
916: INTO l_resource_id
917: FROM PA_RESOURCES_DENORM
918: WHERE person_id = p_person_id
919: AND rownum = 1;
920: ELSE l_resource_id := p_resource_id;
921: END IF;