APPS.PQH_PQHWSEPS_XMLP_PKG SQL Statements

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

Line: 10

        SELECT
          ELEMENT_NAME
        FROM
          PAY_ELEMENT_TYPES
        WHERE ELEMENT_TYPE_ID = P_ELEMENT_TYPE_ID;

Line: 16

        SELECT
          MEANING
        FROM
          HR_LOOKUPS
        WHERE LOOKUP_TYPE = 'PQH_POSITION_TYPE'
          AND LOOKUP_CODE = P_POSITION_TYPE;

Line: 23

        SELECT
          NAME
        FROM
          FND_CURRENCIES_ACTIVE_V
        WHERE CURRENCY_CODE <> 'STAT'
          AND CURRENCY_CODE = P_CURRENCY_CODE;

Line: 30

        SELECT
          sysdate
        FROM
          DUAL;

Line: 68

      SELECT
        SYSTEM_TYPE_CD
      FROM
        PER_SHARED_TYPES
      WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID;

Line: 100

    INSERT INTO FND_SESSIONS
      (SESSION_ID
      ,EFFECTIVE_DATE)
    VALUES   (USERENV('sessionid')
      ,P_EFFECTIVE_DATE);

Line: 178

      SELECT
        SYSTEM_TYPE_CD
      FROM
        PER_SHARED_TYPES
      WHERE SHARED_TYPE_ID = ELM_BUDGET_UNIT_ID;

Line: 232

      SELECT
        SYSTEM_TYPE_CD
      FROM
        PER_SHARED_TYPES
      WHERE SHARED_TYPE_ID = ELM_BUDGET_UNIT_ID
        AND LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE';

Line: 263

      SELECT
        SYSTEM_TYPE_CD
      FROM
        PER_SHARED_TYPES
      WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID
        AND LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE';