APPS.QA_QLTPLACR_XMLP_PKG SQL Statements

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

Line: 11

      SELECT
        NAME
      INTO P_PLAN_NAME
      FROM
        QA_PLANS
      WHERE PLAN_ID = P_PLAN_NAME;

Line: 21

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

Line: 35

      SELECT
        NAME
      INTO P_ELEMENT
      FROM
        QA_CHARS
      WHERE CHAR_ID = P_ELEMENT;

Line: 45

      SELECT
        MEANING
      INTO P_ELEMENT_ENABLED_MEANING
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_TYPE = 'SYS_YES_NO'
        AND LOOKUP_CODE = P_ELEMENT_ENABLED;

Line: 61

      SELECT
        LOOKUP_CODE
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_TYPE = 'SYS_YES_NO'
        AND MEANING = ENABLED_MEANNING;