APPS.QA_QLTPLCHR_XMLP_PKG SQL Statements

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

Line: 27

      SELECT
        MEANING
      INTO P_PLAN_TYPE_MEANING
      FROM
        FND_COMMON_LOOKUPS
      WHERE LOOKUP_TYPE = 'COLLECTION_PLAN_TYPE'
        AND LOOKUP_CODE = P_PLAN_TYPE_DESC;

Line: 36

      SELECT
        NAME
      INTO P_PLAN
      FROM
        QA_PLANS
      WHERE PLAN_ID = P_PLAN;

Line: 46

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

Line: 73

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