APPS.PSB_PSBRPPSV_XMLP_PKG SQL Statements

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

Line: 14

        SELECT
          NAME
        FROM
          PSB_BUDGET_STAGES
        WHERE BUDGET_STAGE_ID = P_STAGE1;

Line: 33

        SELECT
          NAME
        FROM
          PSB_BUDGET_STAGES
        WHERE BUDGET_STAGE_ID = P_STAGE2;

Line: 52

        SELECT
          NAME
        FROM
          PSB_BUDGET_STAGES
        WHERE BUDGET_STAGE_ID = P_STAGE3;

Line: 107

        SELECT
          count(*)
        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_WS_FTE_LINES PWFL,
          PSB_WS_POSITION_LINES PWPL,
          PSB_POSITIONS PP,
          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 PWAL.POSITION_LINE_ID = PWPL.POSITION_LINE_ID
          AND PWPL.POSITION_ID = PP.POSITION_ID
          AND PWPL.POSITION_ID = PWFL.POSITION_LINE_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 )
          AND PWAL.BUDGET_YEAR_ID LIKE NVL(P_BUDGET_YEAR_ID
           ,PWAL.BUDGET_YEAR_ID);