APPS.PSB_PSBRPACV_XMLP_PKG SQL Statements

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

Line: 7

        SELECT
          NAME
        FROM
          PSB_BUDGET_STAGES
        WHERE BUDGET_STAGE_ID = P_STAGE1;

Line: 26

        SELECT
          NAME
        FROM
          PSB_BUDGET_STAGES
        WHERE BUDGET_STAGE_ID = P_STAGE2;

Line: 45

        SELECT
          NAME
        FROM
          PSB_BUDGET_STAGES
        WHERE BUDGET_STAGE_ID = P_STAGE3;

Line: 68

        SELECT
          NAME
        FROM
          PSB_BUDGET_STAGES
        WHERE BUDGET_STAGE_ID = P_STAGE4;

Line: 98

    SELECT
      count(*)
    INTO VDATAFOUND
    FROM
      PSB_WORKSHEETS PW,
      PSB_WS_LINES PWL,
      PSB_WS_ACCOUNT_LINES PWAL,
      PSB_SERVICE_PACKAGES PSP,
      PSB_BUDGET_GROUPS PBG,
      PSB_BUDGET_STAGE_SETS PBSS,
      PSB_BUDGET_STAGES PBS,
      PSB_BUDGET_PERIODS PBP
    WHERE PW.WORKSHEET_ID = PWL.WORKSHEET_ID
      AND PWL.ACCOUNT_LINE_ID = PWAL.ACCOUNT_LINE_ID
      AND PW.BUDGET_GROUP_ID = PBG.BUDGET_GROUP_ID
      AND PWAL.SERVICE_PACKAGE_ID = PSP.SERVICE_PACKAGE_ID
      AND PW.STAGE_SET_ID = PBSS.BUDGET_STAGE_SET_ID
      AND PBS.BUDGET_STAGE_SET_ID = PBSS.BUDGET_STAGE_SET_ID
      AND PBP.BUDGET_PERIOD_ID = PWAL.BUDGET_YEAR_ID
      AND PBS.SEQUENCE_NUMBER BETWEEN PWAL.START_STAGE_SEQ
      AND NVL(PWAL.END_STAGE_SEQ
       ,PWAL.CURRENT_STAGE_SEQ)
      AND BALANCE_TYPE = 'E'
      AND PW.WORKSHEET_ID = P_WORKSHEET_ID
      AND PBS.BUDGET_STAGE_ID IN ( P_STAGE1 , P_STAGE2 , P_STAGE3 , P_STAGE4 )
      AND PWAL.BUDGET_YEAR_ID LIKE NVL(P_BUDGET_YEAR_ID
       ,PWAL.BUDGET_YEAR_ID);

Line: 135

      SELECT
        CONCATENATED_SEGMENTS
      FROM
        GL_CODE_COMBINATIONS_KFV
      WHERE CODE_COMBINATION_ID = CC_ID;