DBA Data[Home] [Help]

APPS.BIS_ACTUAL_VALIDATE_PVT SQL Statements

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

Line: 65

    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_ACTUAL_Rec.TARGET_LEVEL_ID;
Line: 133

    SELECT *
    INTO l_bisbv_TARGET_levels
    FROM BISBV_TARGET_LEVELS bisbv_TARGET_levels
    WHERE bisbv_TARGET_levels.TARGET_LEVEL_ID = p_ACTUAL_Rec.TARGET_Level_ID;
Line: 213

    SELECT *
    INTO l_bisbv_TARGET_levels
    FROM BISBV_TARGET_LEVELS bisbv_TARGET_levels
    WHERE bisbv_TARGET_levels.TARGET_LEVEL_ID = p_ACTUAL_Rec.TARGET_Level_ID;
Line: 289

  SELECT *
  INTO l_bisbv_TARGET_levels
  FROM BISBV_TARGET_LEVELS bisbv_TARGET_levels
  WHERE bisbv_TARGET_levels.TARGET_LEVEL_ID = p_ACTUAL_Rec.TARGET_Level_ID;
Line: 368

  SELECT *
  INTO l_bisbv_TARGET_levels
  FROM BISBV_TARGET_LEVELS bisbv_TARGET_levels
  WHERE bisbv_TARGET_levels.TARGET_LEVEL_ID = p_ACTUAL_Rec.TARGET_Level_ID;
Line: 447

  SELECT *
  INTO l_bisbv_TARGET_levels
  FROM bisbv_TARGET_LEVELS bisbv_TARGET_levels
  WHERE bisbv_TARGET_levels.TARGET_level_ID = p_ACTUAL_Rec.TARGET_level_ID;
Line: 526

  SELECT *
  INTO l_bisbv_TARGET_levels
  FROM bisbv_TARGET_LEVELS bisbv_TARGET_levels
  WHERE bisbv_TARGET_levels.TARGET_level_ID = p_ACTUAL_Rec.TARGET_level_ID;
Line: 604

  SELECT *
  INTO l_bisbv_TARGET_levels
  FROM bisbv_TARGET_LEVELS bisbv_TARGET_levels
  WHERE bisbv_TARGET_levels.TARGET_level_ID = p_ACTUAL_Rec.TARGET_level_ID;
Line: 683

  SELECT *
  INTO l_bisbv_TARGET_levels
  FROM bisbv_TARGET_LEVELS bisbv_TARGET_levels
  WHERE bisbv_TARGET_levels.TARGET_level_ID = p_ACTUAL_Rec.TARGET_level_ID;
Line: 762

  SELECT *
  INTO l_bisbv_TARGET_levels
  FROM bisbv_TARGET_LEVELS bisbv_TARGET_levels
  WHERE bisbv_TARGET_levels.TARGET_level_ID = p_ACTUAL_Rec.TARGET_level_ID;