APPS.QA_QLTSPECR_XMLP_PKG SQL Statements

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

Line: 54

      SELECT
        SPEC_NAME
      INTO P_SPEC_NAME
      FROM
        QA_SPECS
      WHERE SPEC_ID = P_SPEC_NAME;

Line: 67

      SELECT
        MEANING
      INTO P_SPEC_TYPE_MEANING
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_TYPE = 'QA_SPEC_TYPE'
        AND LOOKUP_CODE = P_SPEC_TYPE;