DBA Data[Home] [Help]

APPS.QA_QLTCHWUR_XMLP_PKG SQL Statements

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

Line: 6

      SELECT
        NAME
      INTO P_CHARACTERISTIC
      FROM
        QA_CHARS
      WHERE CHAR_ID = P_CHARACTERISTIC;
Line: 19

      SELECT
        MEANING
      INTO P_CHAR_ENABLED_MEANING
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_TYPE = 'SYS_YES_NO'
        AND LOOKUP_CODE = P_CHAR_ENABLED;
Line: 29

      SELECT
        MEANING
      INTO P_PLAN_ENABLED_MEANING
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_TYPE = 'SYS_YES_NO'
        AND LOOKUP_CODE = P_PLAN_CHAR_ENABLED;