APPS.BOM_CALENDARS_PKG dependencies on BOM_SHIFT_EXCEPTIONS

Line 53: from BOM_SHIFT_EXCEPTIONS

49: from BOM_CALENDAR_EXCEPTIONS
50: where calendar_code = x_calendar_code;
51:
52: select max(exception_date) into shift_except_date
53: from BOM_SHIFT_EXCEPTIONS
54: where calendar_code = x_calendar_code;
55:
56: if (cal_except_date is NULL and shift_except_date is NULL) then
57: x_hi_except_date := NULL;

Line 79: from BOM_SHIFT_EXCEPTIONS

75: select min(exception_date) into cal_except_date
76: from BOM_CALENDAR_EXCEPTIONS
77: where calendar_code = x_calendar_code;
78: select min(exception_date) into shift_except_date
79: from BOM_SHIFT_EXCEPTIONS
80: where calendar_code = x_calendar_code;
81:
82: if (cal_except_date is NULL and shift_except_date is NULL) then
83: x_lo_except_date := NULL;

Line 149: (select 1 from BOM_SHIFT_EXCEPTIONS

145: x_exception_date DATE) IS
146: dummy NUMBER;
147: BEGIN
148: select 1 into dummy from DUAL where not exists
149: (select 1 from BOM_SHIFT_EXCEPTIONS
150: where calendar_code = x_calendar_code
151: and shift_num = x_shift_num
152: and exception_date = x_exception_date
153: );