APPS.BIS_PMF_UTILITIES_PUB SQL Statements

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

Line: 36

    SELECT LEVEL_ID
    INTO l_level_id
    FROM BIS_LEVELS
    WHERE SHORT_NAME = p_Level_Short_Name;

Line: 66

  SELECT TARGET_LEVEL_ID
  INTO l_target_level
  FROM BIS_TARGET_LEVELS L
  WHERE L.SHORT_NAME = p_TARGET_LEVEL_SHORT_NAME;

Line: 113

  SELECT TARGET_LEVEL_ID
  INTO l_target_level
  FROM
    BIS_TARGET_LEVELS L
  , BIS_INDICATORS I
  WHERE I.INDICATOR_ID        = L.INDICATOR_ID
    AND I.SHORT_NAME          = p_MEASURE_SHORT_NAME
    AND L.ORG_LEVEL_ID        = p_ORG_LEVEL
    AND L.TIME_LEVEL_ID       = p_TIME_LEVEL
    AND ( ( p_DIMENSION1_LEVEL IS NOT NULL
            AND L.DIMENSION1_LEVEL_ID = p_DIMENSION1_LEVEL
          )
          OR
          ( p_DIMENSION1_LEVEL IS NULL
          )
        )
    AND ( ( p_DIMENSION2_LEVEL IS NOT NULL
            AND L.DIMENSION2_LEVEL_ID = p_DIMENSION2_LEVEL
          )
          OR
          ( p_DIMENSION2_LEVEL IS NULL
          )
        )
    AND ( ( p_DIMENSION3_LEVEL IS NOT NULL
            AND L.DIMENSION3_LEVEL_ID = p_DIMENSION3_LEVEL
          )
          OR
          ( p_DIMENSION3_LEVEL IS NULL
          )
        )
    AND ( ( p_DIMENSION4_LEVEL IS NOT NULL
            AND L.DIMENSION4_LEVEL_ID = p_DIMENSION4_LEVEL
          )
          OR
          ( p_DIMENSION4_LEVEL IS NULL
          )
        )
    AND ( ( p_DIMENSION5_LEVEL IS NOT NULL
            AND L.DIMENSION5_LEVEL_ID = p_DIMENSION5_LEVEL
          )
          OR
          ( p_DIMENSION5_LEVEL IS NULL
          )
        );

Line: 218

  SELECT TARGET_LEVEL_ID
  INTO l_target_level
  FROM
    BIS_TARGET_LEVELS L
  , BIS_INDICATORS I
  WHERE I.INDICATOR_ID        = L.INDICATOR_ID
    AND I.SHORT_NAME          = p_MEASURE_SHORT_NAME
    AND L.ORG_LEVEL_ID        = l_ORG_LEVEL_ID
    AND L.TIME_LEVEL_ID       = l_TIME_LEVEL_ID
    AND ((l_DIMENSION1_LEVEL_ID IS NOT NULL
         AND L.DIMENSION1_LEVEL_ID = l_DIMENSION1_LEVEL_ID)
         OR (l_DIMENSION1_LEVEL_ID IS NULL))
    AND ((l_DIMENSION2_LEVEL_ID IS NOT NULL
         AND L.DIMENSION2_LEVEL_ID = l_DIMENSION2_LEVEL_ID)
         OR (l_DIMENSION2_LEVEL_ID IS NULL))
    AND ((l_DIMENSION3_LEVEL_ID IS NOT NULL
         AND L.DIMENSION3_LEVEL_ID = l_DIMENSION3_LEVEL_ID)
         OR (l_DIMENSION3_LEVEL_ID IS NULL))
    AND ((l_DIMENSION4_LEVEL_ID IS NOT NULL
         AND L.DIMENSION4_LEVEL_ID = l_DIMENSION4_LEVEL_ID)
         OR (l_DIMENSION4_LEVEL_ID IS NULL))
    AND ((l_DIMENSION5_LEVEL_ID IS NOT NULL
         AND L.DIMENSION5_LEVEL_ID = l_DIMENSION5_LEVEL_ID)
         OR (l_DIMENSION5_LEVEL_ID IS NULL));

Line: 280

  SELECT PLAN_ID
    INTO l_plan_id
    FROM BIS_BUSINESS_PLANS_VL
   WHERE NAME = p_PLAN_NAME ;

Line: 285

  SELECT TARGET
    INTO l_target
    FROM BIS_TARGET_VALUES
   WHERE TARGET_LEVEL_ID = P_TARGET_LEVEL_ID
     AND PLAN_ID         = l_plan_id
     AND ORG_LEVEL_VALUE = P_ORG_LEVEL_VALUE
     AND UPPER(TIME_LEVEL_VALUE) = UPPER(p_TIME_LEVEL_VALUE)
     AND ((p_DIMENSION1_LEVEL_VALUE IS NOT NULL
       AND DIMENSION1_LEVEL_VALUE = p_DIMENSION1_LEVEL_VALUE )
       OR (p_DIMENSION1_LEVEL_VALUE IS NULL))
     AND ((p_DIMENSION2_LEVEL_VALUE IS NOT NULL
       AND DIMENSION2_LEVEL_VALUE = p_DIMENSION2_LEVEL_VALUE )
       OR (p_DIMENSION2_LEVEL_VALUE IS NULL))
     AND ((p_DIMENSION3_LEVEL_VALUE IS NOT NULL
       AND DIMENSION3_LEVEL_VALUE = p_DIMENSION3_LEVEL_VALUE )
       OR (p_DIMENSION3_LEVEL_VALUE IS NULL))
     AND ((p_DIMENSION4_LEVEL_VALUE IS NOT NULL
       AND DIMENSION4_LEVEL_VALUE = p_DIMENSION4_LEVEL_VALUE )
       OR (p_DIMENSION4_LEVEL_VALUE IS NULL))
     AND ((p_DIMENSION5_LEVEL_VALUE IS NOT NULL
       AND DIMENSION5_LEVEL_VALUE = p_DIMENSION5_LEVEL_VALUE )
       OR (p_DIMENSION5_LEVEL_VALUE IS NULL)) ;