DBA Data[Home] [Help]

APPS.QA_QLTCHARR_XMLP_PKG SQL Statements

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

Line: 18

      SELECT
        NAME
      INTO P_ELEMENT
      FROM
        QA_CHARS
      WHERE CHAR_ID = P_ELEMENT;
Line: 30

      SELECT
        MEANING
      INTO P_ENABLED_MEANING
      FROM
        MFG_LOOKUPS
      WHERE LOOKUP_TYPE = 'SYS_YES_NO'
        AND LOOKUP_CODE = P_ENABLED;
Line: 40

      SELECT
        MEANING
      INTO P_ELEMENT_TYPE_MEANING
      FROM
        FND_COMMON_LOOKUPS
      WHERE LOOKUP_TYPE = 'ELEMENT_TYPE'
        AND LOOKUP_CODE = P_ELEMENT_TYPE;