APPS.PQH_PQHWSPBD_XMLP_PKG SQL Statements

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

Line: 8

        SELECT
          NAME
        FROM
          PER_POSITIONS
        WHERE POSITION_ID = P_POSITION_ID;

Line: 14

        SELECT
          NAME
        FROM
          HR_ALL_ORGANIZATION_UNITS_TL
        WHERE LANGUAGE = USERENV('LANG')
          AND ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 21

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

Line: 28

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

Line: 35

        SELECT
          sysdate
        FROM
          DUAL;

Line: 78

      SELECT
        SYSTEM_TYPE_CD
      FROM
        PER_SHARED_TYPES
      WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID;

Line: 110

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

Line: 164

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