APPS.PSB_PSBRPSPU_XMLP_PKG SQL Statements

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

Line: 18

      SELECT
        NAME
      INTO CP_PARAM_WS_NAME
      FROM
        PSB_WORKSHEETS
      WHERE WORKSHEET_ID = P_GLOBAL_WORKSHEET_ID;

Line: 30

      SELECT
        NAME
      INTO CP_PARAM_SP_NAME
      FROM
        PSB_SERVICE_PACKAGES
      WHERE SERVICE_PACKAGE_ID = P_SERVICE_PACKAGE_ID;

Line: 37

    SELECT
      MEANING
    INTO CP_PARAM_ORDER_BY
    FROM
      FND_LOOKUP_VALUES
    WHERE LOOKUP_TYPE = 'PSB_SORT_ORDER_SERVICE_PACKAGE'
      AND LOOKUP_CODE = P_ORDER_BY
      AND LANGUAGE = USERENV('LANG');

Line: 47

      SELECT
        NAME,
        SEQUENCE_NUMBER
      INTO CP_PARAM_STAGE_NAME,CP_SEQUENCE_NUMBER
      FROM
        PSB_BUDGET_STAGES
      WHERE BUDGET_STAGE_ID = P_STAGE_ID;

Line: 65

    SELECT_AMT := 'A.EST_AMT';

Line: 135

  FUNCTION SELECT_AMT_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_AMT;

Line: 138

  END SELECT_AMT_P;