APPS.INV_INVARUIR_XMLP_PKG SQL Statements

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

Line: 67

        SELECT
          MFG.MEANING
        INTO LOCAL_VAR
        FROM
          MFG_LOOKUPS MFG
        WHERE MFG.LOOKUP_TYPE = 'MTL_CC_SCHED_TIME'
          AND MFG.LOOKUP_CODE = C_SCHEDINTERVAL;

Line: 91

      SELECT
        TO_CHAR(MAX(BY1.YEAR_START_DATE)
               ,'DD-MON-RRRR'),
        TO_CHAR(MIN(BY2.YEAR_START_DATE) - 1
               ,'DD-MON-RRRR')
      INTO YEARBEGINDATE,YEARENDDATE
      FROM
        BOM_CAL_YEAR_START_DATES BY1,
        BOM_CAL_YEAR_START_DATES BY2
      WHERE BY1.CALENDAR_CODE = S_CALENDARCODE
        AND BY1.EXCEPTION_SET_ID = S_CALENDAREXCEPTION
        AND BY2.CALENDAR_CODE = BY1.CALENDAR_CODE
        AND BY2.EXCEPTION_SET_ID = BY1.EXCEPTION_SET_ID
        AND BY1.YEAR_START_DATE <= TRUNC(SYSDATE)
        AND BY2.YEAR_START_DATE > TRUNC(SYSDATE);

Line: 106

      SELECT
        BC1.NEXT_SEQ_NUM - BC2.NEXT_SEQ_NUM + 1
      INTO NWORKDAYS
      FROM
        BOM_CALENDAR_DATES BC1,
        BOM_CALENDAR_DATES BC2
      WHERE TO_CHAR(BC2.CALENDAR_DATE
             ,'DD-MON-RRRR') = YEARBEGINDATE
        AND TO_CHAR(BC1.CALENDAR_DATE
             ,'DD-MON-RRRR') = YEARENDDATE
        AND BC1.CALENDAR_CODE = S_CALENDARCODE
        AND BC1.EXCEPTION_SET_ID = S_CALENDAREXCEPTION
        AND BC2.CALENDAR_CODE = S_CALENDARCODE
        AND BC2.EXCEPTION_SET_ID = S_CALENDAREXCEPTION;