eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_PMF_DEFINER_WRAPPER_PVT SQL Statements

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

Line: 32


REM | 11-APR-03 sugopal	Not possible to update an existing value with null  |
REM |			in the Create/Update performance measures page -    |
REM |			modified Update_Performance_Measure for bug#2869324 |
REM | 01-MAR-04	gbhaloti Removed the default commit from measure security   |
REM |			 delete bug#3475674				    |
REM | 22-APR-2005 akoduri   Enhancement#3865711 -- Obsolete Seeded Objects  |
REM | 03-MAY-2005  akoduri  Enh #4268374 -- Weighted Average Measures       |
REM +=======================================================================+
*/
g_api_version   NUMBER := 1;

Line: 215


Procedure Update_Performance_Measure(
             p_Measure_ID                 IN   NUMBER   := BIS_UTILITIES_PUB.G_NULL_NUM
           , p_Measure_Short_Name         IN   VARCHAR2
           , p_Measure_Name               IN   VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
           , p_Description                IN   VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
           , p_Dimension1_ID              IN   NUMBER   := BIS_UTILITIES_PUB.G_NULL_NUM
           , p_Dimension2_ID              IN   NUMBER   := BIS_UTILITIES_PUB.G_NULL_NUM
           , p_Dimension3_ID              IN   NUMBER   := BIS_UTILITIES_PUB.G_NULL_NUM
           , p_Dimension4_ID              IN   NUMBER   := BIS_UTILITIES_PUB.G_NULL_NUM
           , p_Dimension5_ID              IN   NUMBER   := BIS_UTILITIES_PUB.G_NULL_NUM
           , p_Dimension6_ID              IN   NUMBER   := BIS_UTILITIES_PUB.G_NULL_NUM
           , p_Dimension7_ID              IN   NUMBER   := BIS_UTILITIES_PUB.G_NULL_NUM
           , p_Unit_Of_Measure_Class      IN   VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
-- Fix for 1850860 starts here
           , p_actual_data_source_type    IN   VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
           , p_actual_data_source         IN   VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
           , p_function_name              IN   VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
           , p_comparison_source          IN   VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
           , p_increase_in_measure        IN   VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
-- Fix for 1850860 ends here
           , p_enable_link                IN   VARCHAR2 := c_hide_url  -- 2440739
           , p_obsolete                   IN   VARCHAR2 := FND_API.G_FALSE --3865711
	   , p_measure_type               IN   VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
           , p_application_id             IN   NUMBER   := c_default_appl -- 2465354
           , x_return_status              OUT NOCOPY  VARCHAR2
           , x_msg_count                  OUT NOCOPY  VARCHAR2
           , x_msg_data                   OUT NOCOPY  VARCHAR2
           )
IS

l_return_status   varchar2(32000);

Line: 274


  BIS_MEASURE_PUB.Update_Measure( p_api_version   => g_api_version
                                , p_commit        => fnd_api.G_TRUE
                                , p_Measure_Rec   => l_measure_rec
                                , x_return_status => l_return_status
                                , x_error_tbl     => l_error_tbl
                                );

Line: 313


END Update_Performance_Measure;

Line: 315


Procedure Delete_Performance_Measure(
             p_Measure_ID                 IN   NUMBER   := BIS_UTILITIES_PUB.G_NULL_NUM
           , p_Measure_Short_Name         IN   VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
           ,x_return_status                 OUT NOCOPY  VARCHAR2
           ,x_msg_count                  OUT NOCOPY  VARCHAR2
           ,x_msg_data                   OUT NOCOPY  VARCHAR2
           )
IS

l_return_status   varchar2(32000);

Line: 346


  BIS_MEASURE_PUB.Delete_Measure( p_api_version   => g_api_version
                                , p_commit        => fnd_api.G_TRUE
                                , p_Measure_Rec   => l_measure_rec
                                , x_return_status => l_return_status
                                , x_error_tbl     => l_error_tbl
                                );

Line: 408


END Delete_Performance_Measure;

Line: 410


Procedure Delete_target_levels(
     P_TARGET_LEVEL_ID           IN NUMBER
   , p_force_delete              IN NUMBER := 0 --gbhaloti #3148615
   , P_TARGET_LEVEL_SHORT_NAME   IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
   ,x_return_status                 OUT NOCOPY  VARCHAR2
   ,x_msg_count                  OUT NOCOPY  VARCHAR2
   ,x_msg_data                   OUT NOCOPY  VARCHAR2
                      )
IS

l_return_status     varchar2(32000);

Line: 440


    BIS_Target_Level_PVT.Delete_Target_Level
    ( p_api_version         => g_api_version
    , p_force_delete        => p_force_delete   --gbhaloti #3148615
    , p_commit              => fnd_api.G_TRUE
    , p_Target_Level_Rec    => l_Target_Level_Rec
    , x_return_status       => l_return_status
    , x_error_Tbl           => l_error_Tbl
    );

Line: 469


end Delete_target_levels;

Line: 472


Procedure Update_target_levels(
     P_TARGET_LEVEL_ID           IN NUMBER
   , P_TARGET_LEVEL_SHORT_NAME   IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
   , P_TARGET_LEVEL_NAME         IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
   , P_DESCRIPTION               IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
   , P_MEASURE_ID                IN NUMBER   := BIS_UTILITIES_PUB.G_NULL_NUM
   , P_DIMENSION1_LEVEL_ID       IN NUMBER   := BIS_UTILITIES_PUB.G_NULL_NUM
   , P_DIMENSION2_LEVEL_ID       IN NUMBER   := BIS_UTILITIES_PUB.G_NULL_NUM
   , P_DIMENSION3_LEVEL_ID       IN NUMBER   := BIS_UTILITIES_PUB.G_NULL_NUM
   , P_DIMENSION4_LEVEL_ID       IN NUMBER   := BIS_UTILITIES_PUB.G_NULL_NUM
   , P_DIMENSION5_LEVEL_ID       IN NUMBER   := BIS_UTILITIES_PUB.G_NULL_NUM
   , P_DIMENSION6_LEVEL_ID       IN NUMBER   := BIS_UTILITIES_PUB.G_NULL_NUM
   , P_DIMENSION7_LEVEL_ID       IN NUMBER   := BIS_UTILITIES_PUB.G_NULL_NUM
   , P_WORKFLOW_ITEM_TYPE        IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
   , P_WORKFLOW_PROCESS_SHORT_NAME
                                 IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
   , P_DEFAULT_NOTIFY_RESP_ID
                                 IN NUMBER   := BIS_UTILITIES_PUB.G_NULL_NUM
   , P_DEFAULT_NOT_RESP_SHORT_NAME
                                 IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
   , P_COMPUTING_FUNCTION_ID     IN NUMBER   := BIS_UTILITIES_PUB.G_NULL_NUM
   , P_COMPUTING_FUNCTION_NAME   IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
   , P_REPORT_FUNCTION_ID        IN NUMBER   := BIS_UTILITIES_PUB.G_NULL_NUM
   , P_UNIT_OF_MEASURE           IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
   , p_SOURCE                    IN VARCHAR2
   , p_IS_SEED_USER              IN VARCHAR2 := 'N' --2465354
   ,x_return_status              OUT NOCOPY  VARCHAR2
   ,x_msg_count                  OUT NOCOPY  VARCHAR2
   ,x_msg_data                   OUT NOCOPY  VARCHAR2

                      )
IS

l_return_status     varchar2(32000);

Line: 625


    BIS_Target_Level_PVT.Update_Target_Level
    ( p_api_version         => g_api_version
    , p_commit              => fnd_api.G_TRUE
    , p_Target_Level_Rec    => l_Target_Level_Rec
    , p_owner               => l_owner --2465354
    , x_return_status       => l_return_status
    , x_error_Tbl           => l_error_Tbl
    );

Line: 654


end Update_target_levels;

Line: 999


Procedure Delete_Measure_Security(
      P_Target_Level_ID            IN NUMBER       := BIS_UTILITIES_PUB.G_NULL_NUM
    , P_Responsibility_ID          IN NUMBER       := BIS_UTILITIES_PUB.G_NULL_NUM
    ,x_return_status                 OUT NOCOPY  VARCHAR2
    ,x_msg_count                  OUT NOCOPY  VARCHAR2
    ,x_msg_data                   OUT NOCOPY  VARCHAR2
)
IS

l_Measure_Security_Rec BIS_MEASURE_SECURITY_PUB.Measure_Security_Rec_Type;

Line: 1028


    BIS_MEASURE_SECURITY_PVT.Delete_Measure_Security
    ( p_api_version          => g_api_version
    , p_commit               => fnd_api.G_FALSE --gbhaloti, removed commit for #3475674
    , p_Measure_Security_Rec => l_Measure_Security_Rec
    , x_return_status        => l_return_status
    , x_error_Tbl            => l_error_Tbl
    );

Line: 1056


END Delete_Measure_Security;

Line: 1272


          BIS_TARGET_PVT.UPDATE_TARGET
          (p_api_version => 1.0
	  ,p_is_dbimeasure => p_is_dbimeasure --gbhaloti #3148615
          ,p_commit => FND_API.G_TRUE
          ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
          ,p_target_rec => l_target_rec
          ,x_return_status => x_return_status
          ,x_error_tbl => l_error_tbl
          );

Line: 1305


PROCEDURE UPDATE_TARGET
(p_target_id                       IN NUMBER      := BIS_UTILITIES_PUB.G_NULL_NUM
,p_target_level_id		   IN NUMBER	  := BIS_UTILITIES_PUB.G_NULL_NUM
,p_Target_Level_Short_Name         IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_Target_Level_Name		   IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_plan_id			   IN NUMBER      := BIS_UTILITIES_PUB.G_NULL_NUM
,p_plan_name			   IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_dim1_level_value_id		   IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_dim1_level_value_name	   IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_dim2_level_value_id		   IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_dim2_level_value_name	   IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_dim3_level_value_id		   IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_dim3_level_value_name	   IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_dim4_level_value_id		   IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_dim4_level_value_name	   IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_dim5_level_value_id		   IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_dim5_level_value_name	   IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_dim6_level_value_id		   IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_dim6_level_value_name	   IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_dim7_level_value_id		   IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_dim7_level_value_name	   IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_target			   IN NUMBER      := BIS_UTILITIES_PUB.G_NULL_NUM
,p_range1_low			   IN NUMBER      := BIS_UTILITIES_PUB.G_NULL_NUM
,p_range1_high			   IN NUMBER      := BIS_UTILITIES_PUB.G_NULL_NUM
,p_range2_low			   IN NUMBER      := BIS_UTILITIES_PUB.G_NULL_NUM
,p_range2_high			   IN NUMBER      := BIS_UTILITIES_PUB.G_NULL_NUM
,p_range3_low			   IN NUMBER      := BIS_UTILITIES_PUB.G_NULL_NUM
,p_range3_high			   IN NUMBER      := BIS_UTILITIES_PUB.G_NULL_NUM
,p_notify_resp1_id		   IN NUMBER      := BIS_UTILITIES_PUB.G_NULL_NUM
,p_notify_resp1_short_name         IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_notify_resp1_name               IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_notify_resp2_id		   IN NUMBER      := BIS_UTILITIES_PUB.G_NULL_NUM
,p_notify_resp2_short_name         IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_notify_resp2_name               IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_notify_resp3_id		   IN NUMBER      := BIS_UTILITIES_PUB.G_NULL_NUM
,p_notify_resp3_short_name         IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,p_notify_resp3_name               IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,x_return_status			   OUT NOCOPY VARCHAR2
,x_msg_count			   OUT NOCOPY NUMBER
,x_msg_data                   OUT NOCOPY  VARCHAR2

)
IS
  l_target_rec			  BIS_TARGET_PUB.TARGET_REC_TYPE;

Line: 1393


       BIS_TARGET_PVT.UPDATE_TARGET
       (p_api_version => 1.0
       ,p_commit => FND_API.G_TRUE
       ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
       ,p_target_rec => l_target_rec
       ,x_return_status => x_return_status
       ,x_error_tbl => l_error_tbl
       );

Line: 1422


PROCEDURE DELETE_TARGET
(p_target_id                      IN NUMBER      := BIS_UTILITIES_PUB.G_NULL_NUM
,p_Target_level_id                IN NUMBER      := BIS_UTILITIES_PUB.G_NULL_NUM
,p_target_level_short_name        IN VARCHAR2    := BIS_UTILITIES_PUB.G_NULL_CHAR
,x_return_status                  OUT NOCOPY VARCHAR2
,x_msg_count                      OUT NOCOPY NUMBER
,x_msg_data                       OUT NOCOPY VARCHAR2
)
IS
  l_TargeT_rec                   BIS_TARGET_PUB.TARGET_REC_TYPE;

Line: 1440


  BIS_TARGET_PVT.DELETE_TARGET
  (p_api_version => 1.0
  ,p_commit      => FND_API.G_TRUE
  ,p_target_Rec  => l_target_rec
  ,x_return_status => x_return_status
  ,x_error_tbl     => l_error_tbl
  );

Line: 1483


  SELECT x.sequence_no
  FROM bis_indicator_dimensions x, bis_dimensions y
  WHERE x.indicator_id = p_performance_measure_id AND
        y.dimension_id = x.dimension_id AND
        y.short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_SRC(p_source);

Line: 1489


  SELECT x.sequence_no
  FROM bis_indicator_dimensions x, bis_dimensions y
  WHERE x.indicator_id = p_performance_measure_id AND
        y.dimension_id = x.dimension_id AND
        y.short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id,NULL);

Line: 1495


  SELECT x.sequence_no ,
         y.dimension1_level_id, y.dimension1_level_short_name, y.dimension1_level_name,
         y.dimension2_level_id, y.dimension2_level_short_name, y.dimension2_level_name,
         y.dimension3_level_id, y.dimension3_level_short_name, y.dimension3_level_name,
         y.dimension4_level_id, y.dimension4_level_short_name, y.dimension4_level_name,
         y.dimension5_level_id, y.dimension5_level_short_name, y.dimension5_level_name,
         y.dimension6_level_id, y.dimension6_level_short_name, y.dimension6_level_name,
         y.dimension7_level_id, y.dimension7_level_short_name, y.dimension7_level_name
  FROM bis_indicator_dimensions x, bisfv_target_levels y,
       bis_dimensions z
  WHERE y.target_level_id=p_target_level_id AND
        y.measure_id = x.indicator_id AND
        x.dimension_id = z.dimension_id AND
        z.short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id,NULL);

Line: 1668


  SELECT x.sequence_no
  FROM bis_indicator_dimensions x, bis_dimensions y
  WHERE x.indicator_id = p_performance_measure_id AND
        y.dimension_id = x.dimension_id AND
        y.short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id,NULL);

Line: 1674


  SELECT x.sequence_no ,
         y.dimension1_level_id, y.dimension1_level_short_name, y.dimension1_level_name,
         y.dimension2_level_id, y.dimension2_level_short_name, y.dimension2_level_name,
         y.dimension3_level_id, y.dimension3_level_short_name, y.dimension3_level_name,
         y.dimension4_level_id, y.dimension4_level_short_name, y.dimension4_level_name,
         y.dimension5_level_id, y.dimension5_level_short_name, y.dimension5_level_name,
         y.dimension6_level_id, y.dimension6_level_short_name, y.dimension6_level_name,
         y.dimension7_level_id, y.dimension7_level_short_name, y.dimension7_level_name
  FROM bis_indicator_dimensions x, bisfv_target_levels y,
       bis_dimensions z
  WHERE y.target_level_id=p_target_level_id AND
        y.measure_id = x.indicator_id AND
        x.dimension_id = z.dimension_id AND
        z.short_name = BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id,NULL);

Line: 1809


  SELECT x.sequence_no
  FROM bis_indicator_dimensions x, bis_dimensions y
  WHERE x.indicator_id = p_performance_measure_id AND
        y.dimension_id = x.dimension_id AND
        y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_SRC(p_source);

Line: 1815


  SELECT x.sequence_no
  FROM bis_indicator_dimensions x, bis_dimensions y
  WHERE x.indicator_id = p_performance_measure_id AND
        y.dimension_id = x.dimension_id AND
        y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL);

Line: 1821


  SELECT x.sequence_no ,
         y.dimension1_level_id, y.dimension1_level_short_name, y.dimension1_level_name,
         y.dimension2_level_id, y.dimension2_level_short_name, y.dimension2_level_name,
         y.dimension3_level_id, y.dimension3_level_short_name, y.dimension3_level_name,
         y.dimension4_level_id, y.dimension4_level_short_name, y.dimension4_level_name,
         y.dimension5_level_id, y.dimension5_level_short_name, y.dimension5_level_name,
         y.dimension6_level_id, y.dimension6_level_short_name, y.dimension6_level_name,
         y.dimension7_level_id, y.dimension7_level_short_name, y.dimension7_level_name
  FROM bis_indicator_dimensions x, bisfv_target_levels y,
       bis_dimensions z
  WHERE y.target_level_id=p_target_level_id AND
        y.measure_id = x.indicator_id AND
        x.dimension_id = z.dimension_id AND
        z.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL);

Line: 1996


  SELECT x.sequence_no
  FROM bis_indicator_dimensions x, bis_dimensions y
  WHERE x.indicator_id = p_performance_measure_id AND
        y.dimension_id = x.dimension_id AND
        y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL);

Line: 2002


  SELECT x.sequence_no ,
         y.dimension1_level_id, y.dimension1_level_short_name, y.dimension1_level_name,
         y.dimension2_level_id, y.dimension2_level_short_name, y.dimension2_level_name,
         y.dimension3_level_id, y.dimension3_level_short_name, y.dimension3_level_name,
         y.dimension4_level_id, y.dimension4_level_short_name, y.dimension4_level_name,
         y.dimension5_level_id, y.dimension5_level_short_name, y.dimension5_level_name,
         y.dimension6_level_id, y.dimension6_level_short_name, y.dimension6_level_name,
         y.dimension7_level_id, y.dimension7_level_short_name, y.dimension7_level_name
  FROM bis_indicator_dimensions x, bisfv_target_levels y,
       bis_dimensions z
  WHERE y.target_level_id=p_target_level_id AND
        y.measure_id = x.indicator_id AND
        x.dimension_id = z.dimension_id AND
        z.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL);

Line: 2541


  SELECT level_id
  FROM bis_levels
  WHERE short_name=p_dim_level_short_name;

Line: 2545


  SELECT responsibility_id
  FROM fnd_user_resp_groups
  WHERE user_id=p_user_id;

Line: 2549


  SELECT responsibility_id
  FROM bis_indicator_Resps
  WHERE target_level_id=p_target_level_id;

Line: 2686


     SELECT name INTO x_plan_name
     FROM BIS_BUSINESS_PLANS_VL
     WHERE PLAN_ID=p_plan_id;

Line: 2805


PROCEDURE UPDATE_MEASURE_SECURITY
  (
    p_target_level_id     IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM,
    p_responsibilities    IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR,
    x_return_status       OUT NOCOPY VARCHAR2,
    x_msg_count           OUT NOCOPY VARCHAR2,
    x_msg_data            OUT NOCOPY VARCHAR2
  )
IS
  l_return_status         VARCHAR2(32000);

Line: 2830


  BIS_MEASURE_SECURITY_PVT.DELETE_MEASURE_SECURITY
    (
      p_api_version => g_api_version,
      p_commit => FND_API.G_FALSE,
      p_target_level_rec => l_target_level_rec,
      x_return_status => l_return_status,
      x_error_tbl => l_error_tbl
    );

Line: 2883


END UPDATE_MEASURE_SECURITY;

Line: 2978


     select target_level_id from bisfv_target_levels where measure_id = p_measure_id
     and target_level_id in (select distinct ir.target_level_id from bis_indicator_resps  ir
     , fnd_user_resp_groups ur
     , bisbv_target_levels  il
      where ur.user_id           = p_user_id
      and   ir.responsibility_id = ur.responsibility_id
      and   il.target_level_id   = ir.target_level_id and il.target_level_id=p_target_level_id);