DBA Data[Home] [Help]

APPS.WSH_CALENDAR_ACTIONS dependencies on BOM_SHIFT_DATES

Line 45: BOM_SHIFT_DATES BDT, WSH_CALENDAR_ASSIGNMENTS WCA

41:
42: CURSOR get_shift_end_time_today(p_location_id in number, p_date in date) IS
43: SELECT BSH.from_time, BSH.to_time
44: FROM BOM_CALENDAR_SHIFTS BCA, BOM_SHIFT_TIMES BSH,
45: BOM_SHIFT_DATES BDT, WSH_CALENDAR_ASSIGNMENTS WCA
46: WHERE WCA.LOCATION_ID = p_location_id and
47: BCA.CALENDAR_CODE=WCA.CALENDAR_CODE and
48: BSH.CALENDAR_CODE=WCA.CALENDAR_CODE and
49: BCA.SHIFT_NUM = BSH.SHIFT_NUM and

Line 66: BOM_SHIFT_DATES BDT, WSH_CALENDAR_ASSIGNMENTS WCA

62: -- end tomorrow.
63: CURSOR get_shift_end_time_tomorrow(p_location_id in number, p_date in date) IS
64: SELECT BSH.from_time, BSH.to_time
65: FROM BOM_CALENDAR_SHIFTS BCA, BOM_SHIFT_TIMES BSH,
66: BOM_SHIFT_DATES BDT, WSH_CALENDAR_ASSIGNMENTS WCA
67: WHERE WCA.LOCATION_ID = p_location_id and
68: BCA.CALENDAR_CODE=WCA.CALENDAR_CODE and
69: BSH.CALENDAR_CODE=WCA.CALENDAR_CODE and
70: BCA.SHIFT_NUM = BSH.SHIFT_NUM and