APPS.AHL_VWP_TIMES_PVT dependencies on AHL_DEPARTMENT_SHIFTS

Line 360: -- A Department can have only one shift (ahl_department_shifts)

356: -- Initial Version 1.0
357: --
358: -- ASSUMPTIONS:
359: -- A Task can appear only once for a given visit (ahl_visit_tasks_b)
360: -- A Department can have only one shift (ahl_department_shifts)
361: -- Shift_Num is unique in bom_shift_times
362: --
363: -------------------------------------------------------------------
364: PROCEDURE Calculate_Task_Times

Line 379: FROM AHL_VISITS_B v, AHL_DEPARTMENT_SHIFTS shifts

375: --
376: --Fetch basic visit data
377: CURSOR get_visit_data_csr(p_visit_id IN NUMBER) IS
378: SELECT v.start_date_time, v.department_id
379: FROM AHL_VISITS_B v, AHL_DEPARTMENT_SHIFTS shifts
380: WHERE v.department_id = shifts.department_id
381: AND v.visit_id = p_visit_id;
382: --
383: --Cursor for deriving all the stage start hours

Line 676: FROM AHL_VISITS_B v, AHL_VISIT_TASKS_B vt, AHL_DEPARTMENT_SHIFTS dept

672: --
673: --Cursor for fetching visit info
674: CURSOR get_visit_data_csr(p_task_id IN NUMBER) IS
675: SELECT v.start_date_time, v.department_id, v.visit_id, v.status_code
676: FROM AHL_VISITS_B v, AHL_VISIT_TASKS_B vt, AHL_DEPARTMENT_SHIFTS dept
677: WHERE v.visit_id = vt.visit_id
678: AND dept.department_id = v.department_id
679: AND vt.visit_task_id = p_task_id;
680: --

Line 1144: FROM bom_calendar_exceptions ex, ahl_department_shifts dept

1140: CURSOR get_holiday_csr(p_department_id IN NUMBER,
1141: p_start_date IN DATE,
1142: p_end_date IN DATE) IS
1143: SELECT COUNT(ex.EXCEPTION_DATE)
1144: FROM bom_calendar_exceptions ex, ahl_department_shifts dept
1145: WHERE ex.CALENDAR_CODE = dept.calendar_code
1146: AND EXCEPTION_TYPE = G_HOLIDAY_TYPE
1147: AND dept.department_id = p_department_id
1148: AND ex.exception_date > p_start_date

Line 1338: bom_calendars cal, ahl_department_shifts dept

1334: SELECT TRUNC(cal.CALENDAR_START_DATE), TRUNC(cal.CALENDAR_END_DATE),
1335: times.FROM_TIME/G_SECS_IN_DAY, times.TO_TIME/G_SECS_IN_DAY,
1336: pattern.DAYS_ON, pattern.DAYS_OFF
1337: FROM bom_shift_times times, bom_workday_patterns pattern,
1338: bom_calendars cal, ahl_department_shifts dept
1339: WHERE dept.calendar_code = times.calendar_code
1340: AND dept.shift_num = times.shift_num
1341: AND pattern.calendar_code = dept.calendar_code
1342: AND pattern.shift_num = dept.shift_num

Line 1349: FROM bom_calendar_exceptions ex, ahl_department_shifts dept

1345: --
1346: -- Fetch the holidays for the given department
1347: CURSOR l_exceptions_csr(p_department_id IN NUMBER) IS
1348: SELECT ex.EXCEPTION_DATE
1349: FROM bom_calendar_exceptions ex, ahl_department_shifts dept
1350: WHERE ex.CALENDAR_CODE = dept.calendar_code
1351: AND EXCEPTION_TYPE = G_HOLIDAY_TYPE
1352: AND dept.department_id = p_department_id
1353: ORDER BY EXCEPTION_DATE;