APPS.IGI_IGIPSAPR_XMLP_PKG SQL Statements

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

Line: 12

      SELECT
        DESCRIPTION
      FROM
        IGI_LOOKUPS
      WHERE UPPER(LOOKUP_CODE) = 'SIA'
        AND LOOKUP_TYPE = 'GCC_DESCRIPTION';

Line: 49

      SELECT
        LOOKUP_CODE
      INTO P_RELEASE_LOOKUP_CODE_1
      FROM
        IGI_LOOKUPS
      WHERE LOOKUP_TYPE = 'REPORTS'
        AND MEANING = P_RELEASE_LOOKUP_CODE;