APPS.BIS_TARGET_VALIDATE_PVT SQL Statements

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

Line: 56

    SELECT bisbv_target_levels.TARGET_LEVEL_ID
    INTO l_Target_Level_ID
    FROM bisbv_target_levels bisbv_target_levels
    WHERE bisbv_target_levels.TARGET_LEVEL_ID
          = p_Target_Rec.TARGET_LEVEL_ID;

Line: 131

    SELECT bis_business_plans.PLAN_ID
    INTO l_Plan_ID
    FROM bis_business_plans bis_business_plans
    WHERE bis_business_plans.PLAN_ID
          = p_Target_Rec.PLAN_ID;

Line: 193

  SELECT *
  INTO l_bisbv_target_levels
  FROM BISBV_TARGET_LEVELS bisbv_target_levels
  WHERE bisbv_target_levels.TARGET_LEVEL_ID = p_Target_Rec.Target_Level_ID;

Line: 262

  SELECT *
  INTO l_bisbv_target_levels
  FROM BISBV_TARGET_LEVELS bisbv_target_levels
  WHERE bisbv_target_levels.TARGET_LEVEL_ID = p_Target_Rec.Target_Level_ID;

Line: 331

  SELECT *
  INTO l_bisbv_target_levels
  FROM BISBV_TARGET_LEVELS bisbv_target_levels
  WHERE bisbv_target_levels.TARGET_LEVEL_ID = p_Target_Rec.Target_Level_ID;

Line: 400

  SELECT *
  INTO l_bisbv_target_levels
  FROM BISBV_TARGET_LEVELS bisbv_target_levels
  WHERE bisbv_target_levels.TARGET_LEVEL_ID = p_Target_Rec.Target_Level_ID;

Line: 465

  SELECT *
  INTO l_bisbv_target_levels
  FROM BISBV_TARGET_LEVELS bisbv_target_levels
  WHERE bisbv_target_levels.TARGET_LEVEL_ID = p_Target_Rec.Target_Level_ID;

Line: 530

  SELECT *
  INTO l_bisbv_target_levels
  FROM BISBV_TARGET_LEVELS bisbv_target_levels
  WHERE bisbv_target_levels.TARGET_LEVEL_ID = p_Target_Rec.Target_Level_ID;

Line: 595

  SELECT *
  INTO l_bisbv_target_levels
  FROM BISBV_TARGET_LEVELS bisbv_target_levels
  WHERE bisbv_target_levels.TARGET_LEVEL_ID = p_Target_Rec.Target_Level_ID;

Line: 660

  SELECT *
  INTO l_bisbv_target_levels
  FROM BISBV_TARGET_LEVELS bisbv_target_levels
  WHERE bisbv_target_levels.TARGET_LEVEL_ID = p_Target_Rec.Target_Level_ID;

Line: 724

  SELECT *
  INTO l_bisbv_target_levels
  FROM BISBV_TARGET_LEVELS bisbv_target_levels
  WHERE bisbv_target_levels.TARGET_LEVEL_ID = p_Target_Rec.Target_Level_ID;

Line: 787

  SELECT *
  INTO l_bisbv_target_levels
  FROM BISBV_TARGET_LEVELS bisbv_target_levels
  WHERE bisbv_target_levels.TARGET_LEVEL_ID = p_Target_Rec.Target_Level_ID;