APPS.PA_SCHEDULE_UTILS dependencies on PA_RESOURCES

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;

Line 931: pa_resources res

927: SELECT jtf_cal.calendar_name
928: INTO l_calendar_name
929: FROM jtf_cal_resource_assign jtf_cal_res,
930: jtf_calendars_vl jtf_cal,
931: pa_resources res
932: WHERE res.resource_id = l_resource_id
933: AND jtf_cal_res.resource_id = res.jtf_resource_id
934: AND jtf_cal_res.resource_type_code = 'RS_EMPLOYEE'
935: AND jtf_cal_res.primary_calendar_flag = 'Y'

Line 1040: FROM jtf_cal_resource_assign jtf_res, pa_resources pa_res

1036: FROM (
1037: SELECT jtf_res.calendar_id calendar_id,
1038: NVL(jtf_res.start_date_time, l_start_date) start_date_time,
1039: NVL(jtf_res.end_date_time, l_end_date) end_date_time
1040: FROM jtf_cal_resource_assign jtf_res, pa_resources pa_res
1041: WHERE pa_res.resource_id = p_resource_id
1042: and jtf_res.resource_id = pa_res.jtf_resource_id
1043: and jtf_res.resource_type_code = 'RS_EMPLOYEE'
1044: and jtf_res.calendar_id > -1