APPS.WIP_CALENDAR SQL Statements

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

Line: 27

    SELECT BCD1.CALENDAR_DATE
    FROM   BOM_CALENDAR_DATES BCD1,
           BOM_CALENDAR_DATES BCD2,
           MTL_PARAMETERS MP
    WHERE  MP.ORGANIZATION_ID    = x_org_id
      AND  BCD1.CALENDAR_CODE    = MP.CALENDAR_CODE
      AND  BCD2.CALENDAR_CODE    = MP.CALENDAR_CODE
      AND  BCD1.EXCEPTION_SET_ID = MP.CALENDAR_EXCEPTION_SET_ID
      AND  BCD2.EXCEPTION_SET_ID = MP.CALENDAR_EXCEPTION_SET_ID
      AND  BCD2.CALENDAR_DATE    = TRUNC(x_sched_date)
     AND  BCD1.SEQ_NUM = NVL(BCD2.SEQ_NUM, BCD2.NEXT_SEQ_NUM) + CEIL(lt);

Line: 40

    SELECT BCD1.CALENDAR_DATE
    FROM   BOM_CALENDAR_DATES BCD1,
           BOM_CALENDAR_DATES BCD2,
           MTL_PARAMETERS MP
    WHERE  MP.ORGANIZATION_ID    = x_org_id
      AND  BCD1.CALENDAR_CODE    = MP.CALENDAR_CODE
      AND  BCD2.CALENDAR_CODE    = MP.CALENDAR_CODE
      AND  BCD1.EXCEPTION_SET_ID = MP.CALENDAR_EXCEPTION_SET_ID
      AND  BCD2.EXCEPTION_SET_ID = MP.CALENDAR_EXCEPTION_SET_ID
      AND  BCD2.CALENDAR_DATE    = TRUNC(x_sched_date)
      AND  BCD1.SEQ_NUM = NVL(BCD2.SEQ_NUM, BCD2.PRIOR_SEQ_NUM) -
                             --(new_proc_days) + 1 - CEIL(lt); --Bug2331915

Line: 58

      SELECT nvl(BCD.SEQ_NUM,-1)
      FROM   BOM_CALENDAR_DATES BCD,
             MTL_PARAMETERS MP
      WHERE  MP.ORGANIZATION_ID   = x_org_id
        AND  BCD.CALENDAR_CODE    = MP.CALENDAR_CODE
        AND  BCD.EXCEPTION_SET_ID = MP.CALENDAR_EXCEPTION_SET_ID
        AND  BCD.CALENDAR_DATE    = TRUNC(x_sched_date);