APPS.WSH_CALENDAR_ACTIONS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 43

 SELECT BSH.from_time, BSH.to_time
 FROM BOM_CALENDAR_SHIFTS BCA, BOM_SHIFT_TIMES BSH,
      BOM_SHIFT_DATES BDT,  WSH_CALENDAR_ASSIGNMENTS WCA
 WHERE WCA.LOCATION_ID = p_location_id and
       BCA.CALENDAR_CODE=WCA.CALENDAR_CODE and
       BSH.CALENDAR_CODE=WCA.CALENDAR_CODE and
       BCA.SHIFT_NUM = BSH.SHIFT_NUM and
       BDT.CALENDAR_CODE = WCA.CALENDAR_CODE and
       BDT.SHIFT_NUM = BCA.SHIFT_NUM and
       BDT.EXCEPTION_SET_ID = -1 and
       to_char(BDT.SHIFT_DATE, 'YYYY/MM/DD') = to_char(p_date, 'YYYY/MM/DD') and
       BSH.TO_TIME > BSH.FROM_TIME and
       BSH.TO_TIME > to_number(to_char(p_date, 'SSSSS'))
       ORDER BY BSH.to_time ASC;

Line: 64

 SELECT BSH.from_time, BSH.to_time
 FROM BOM_CALENDAR_SHIFTS BCA, BOM_SHIFT_TIMES BSH,
      BOM_SHIFT_DATES BDT,  WSH_CALENDAR_ASSIGNMENTS WCA
 WHERE WCA.LOCATION_ID = p_location_id and
       BCA.CALENDAR_CODE=WCA.CALENDAR_CODE and
       BSH.CALENDAR_CODE=WCA.CALENDAR_CODE and
       BCA.SHIFT_NUM = BSH.SHIFT_NUM and
       BDT.CALENDAR_CODE = WCA.CALENDAR_CODE and
       BDT.SHIFT_NUM = BCA.SHIFT_NUM and
       BDT.EXCEPTION_SET_ID = -1 and
       to_char(BDT.SHIFT_DATE, 'YYYY/MM/DD')
       = to_char(p_date, 'YYYY/MM/DD') and
       BSH.TO_TIME < BSH.FROM_TIME
       ORDER BY BSH.to_time ASC;