APPS.PA_RESOURCE_UTILS dependencies on PA_SCHEDULES
Line 3153: FROM pa_schedules pas
3149: '5',THURSDAY_HOURS,
3150: '6',FRIDAY_HOURS,
3151: SATURDAY_HOURS )
3152: INTO x_capacity 3153: FROM pa_schedules pas 3154: WHERE p_wk_date BETWEEN pas.start_date AND pas.end_date
3155: AND pas.SCHEDULE_TYPE_CODE = 'CALENDAR'
3156: AND pas.CALENDAR_ID = l_calendar_id
3157: ;