APPS.PSB_PSBRPBRS_XMLP_PKG SQL Statements

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

Line: 47

    SELECT
      DISTINCT
      CURRENCY_CODE
    INTO L_CURRENCY_CODE
    FROM
      PSB_BUDGET_REVISION_ACCOUNTS_V
    WHERE BUDGET_REVISION_ID = P_BUDGET_REVISION_ID;

Line: 91

    SELECT
      CURRENCY_CODE
    INTO L_CURRENCY_CODE
    FROM
      PSB_BUDGET_REVISIONS
    WHERE BUDGET_REVISION_ID = P_BUDGET_REVISION_ID;