APPS.PSB_PSBOTGLR_XMLP_PKG SQL Statements

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

Line: 19

        SELECT
          GL_BUDGET_SET_NAME
        FROM
          PSB_GL_BUDGET_SETS
        WHERE GL_BUDGET_SET_ID = P_GL_BUDGET_SET_ID;

Line: 25

        SELECT
          DECODE(BG.ROOT_CHART_OF_ACCOUNTS_ID
                ,NULL
                ,BG.CHART_OF_ACCOUNTS_ID
                ,BG.ROOT_CHART_OF_ACCOUNTS_ID) R_COA,
          DECODE(BG.ROOT_CURRENCY_CODE
                ,NULL
                ,BG.CURRENCY_CODE
                ,BG.ROOT_CURRENCY_CODE) R_CURR,
          DECODE(BG.ROOT_SOB_NAME
                ,NULL
                ,BG.SOB_NAME
                ,BG.ROOT_SOB_NAME) R_SOB,
          REV.BUDGET_REVISION_TYPE,
          REV.PERMANENT_REVISION
        FROM
          PSB_BUDGET_REVISIONS REV,
          PSB_BUDGET_GROUPS_V BG
        WHERE REV.BUDGET_GROUP_ID = NVL(BG.BUDGET_GROUP_ID
           ,BG.ROOT_SET_OF_BOOKS_ID)
          AND REV.BUDGET_REVISION_ID = P_WORKSHEET_ID;

Line: 53

        SELECT
          DECODE(BG.ROOT_CHART_OF_ACCOUNTS_ID
                ,NULL
                ,BG.CHART_OF_ACCOUNTS_ID
                ,BG.ROOT_CHART_OF_ACCOUNTS_ID),
          DECODE(BG.ROOT_CURRENCY_CODE
                ,NULL
                ,BG.CURRENCY_CODE
                ,BG.ROOT_CURRENCY_CODE),
          DECODE(BG.ROOT_SOB_NAME
                ,NULL
                ,BG.SOB_NAME
                ,BG.ROOT_SOB_NAME)
        INTO COAID,CP_CURRENCY_CODE,CP_SOB_NAME
        FROM
          PSB_BUDGET_GROUPS_V BG,
          PSB_WORKSHEETS WS
        WHERE WS.BUDGET_GROUP_ID = NVL(BG.BUDGET_GROUP_ID
           ,BG.ROOT_BUDGET_GROUP_ID)
          AND WS.WORKSHEET_ID = P_WORKSHEET_ID;

Line: 142

  FUNCTION SELECT_DR_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_DR;

Line: 145

  END SELECT_DR_P;

Line: 154

  FUNCTION SELECT_CR_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_CR;

Line: 157

  END SELECT_CR_P;

Line: 158

  FUNCTION SELECT_ALL_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_ALL;

Line: 161

  END SELECT_ALL_P;