APPS.PQH_PQHWSPCH_XMLP_PKG SQL Statements

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

Line: 8

        SELECT
          NAME
        FROM
          PER_ORGANIZATION_STRUCTURES
        WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
          AND NVL(POSITION_CONTROL_STRUCTURE_FLG
           ,'N') = 'Y';

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_ID1;

Line: 100

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

Line: 156

      SELECT
        SYSTEM_TYPE_CD
      FROM
        PER_SHARED_TYPES
      WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID;

Line: 275

      SELECT
        SYSTEM_TYPE_CD
      FROM
        PER_SHARED_TYPES
      WHERE SHARED_TYPE_ID = BGRP_BUDGET_UNIT_ID;

Line: 351

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

Line: 382

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

Line: 413

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