APPS.PQH_PQHWSBPR_XMLP_PKG SQL Statements

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

Line: 8

        SELECT
          BUDGET_NAME,
          VERSION_NUMBER
        FROM
          PQH_BUDGETS BGT,
          PQH_BUDGET_VERSIONS BVR
        WHERE BGT.BUDGET_ID = BVR.BUDGET_ID
          AND BGT.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
          AND BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;

Line: 18

        SELECT
          BG.CURRENCY_CODE
        FROM
          PER_BUSINESS_GROUPS BG,
          PQH_BUDGETS BGT,
          PQH_BUDGET_VERSIONS BVR
        WHERE BGT.BUDGET_ID = BVR.BUDGET_ID
          AND BVR.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
          AND BGT.BUSINESS_GROUP_ID = BG.BUSINESS_GROUP_ID;

Line: 28

        SELECT
          BGT.CURRENCY_CODE
        FROM
          PQH_BUDGETS BGT,
          PQH_BUDGET_VERSIONS BVR
        WHERE BGT.BUDGET_ID = BVR.BUDGET_ID
          AND BVR.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;

Line: 36

        SELECT
          sysdate
        FROM
          DUAL;

Line: 41

        SELECT
          MEANING
        FROM
          HR_LOOKUPS
        WHERE LOOKUP_TYPE = 'PQH_BUDGET_DETAIL_RECORD_TYPE'
          AND LOOKUP_CODE = P_RECORD_TYPE;

Line: 94

      SELECT
        SYSTEM_TYPE_CD
      FROM
        PER_SHARED_TYPES
      WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID;

Line: 127

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

Line: 183

    SELECT
      SYSTEM_TYPE_CD
    INTO
      BUDGET_UNIT_CD
    FROM
      PER_SHARED_TYPES
    WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID;