APPS.BOM_CALENDAR_API_BK SQL Statements

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

Line: 31

	select CA.seq_num
	into   l_date_seq_num
	from   BOM_CALENDAR_DATES CA
	where  CA.calendar_code = x_calendar_code
	and    CA.calendar_date = trunc(x_date)
	and    CA.exception_set_id = -1;

Line: 78

      	 SELECT CA.shift_num, SH.from_time, SH.to_time, DT.seq_num
      	 FROM BOM_CALENDAR_SHIFTS CA, BOM_SHIFT_TIMES SH,
	      BOM_SHIFT_DATES DT
         WHERE CA.CALENDAR_CODE=x_calendar_code and
	       SH.CALENDAR_CODE=x_calendar_code and
	       CA.SHIFT_NUM = SH.SHIFT_NUM and
	       DT.CALENDAR_CODE = x_calendar_code and
	       DT.SHIFT_NUM = CA.SHIFT_NUM and
	       DT.EXCEPTION_SET_ID = -1 and
	       to_char(DT.SHIFT_DATE, 'YYYY/MM/DD')
               = to_char(x_date, 'YYYY/MM/DD');

Line: 96

    SELECT 1
    INTO dummy
    FROM BOM_CALENDARS
    WHERE CALENDAR_CODE = x_calendar_code;