APPS.GHR_DUT_SHD SQL Statements

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

Line: 67

  SELECT duty_station_id,
         effective_start_date,
         effective_end_date  ,
         locality_pay_area_id,
         leo_pay_area_code,
         name             ,
         duty_station_code,
         msa_code         ,
         cmsa_code        ,
         state_or_country_code,
         county_code           ,
         is_duty_station   ,
	 object_version_number
   FROM  ghr_duty_stations_f
  WHERE  duty_station_id = p_duty_station_id
    AND  p_effective_date  BETWEEN effective_start_date
                               AND effective_end_date;

Line: 145

	 p_delete	 out nocopy boolean,
	 p_future_change out nocopy boolean,
	 p_delete_next_change out nocopy boolean) is
--
  l_proc 		varchar2(72) 	:= g_package||'find_dt_del_modes';

Line: 162

	 p_delete		=> p_delete,
	 p_future_change	=> p_future_change,
	 p_delete_next_change	=> p_delete_next_change);

Line: 177

	 p_update	 out nocopy boolean,
	 p_update_override out nocopy boolean,
	 p_update_change_insert out nocopy boolean) is
--
  l_proc 	varchar2(72) := g_package||'find_dt_upd_modes';

Line: 194

	 p_update		=> p_update,
	 p_update_override	=> p_update_override,
	 p_update_change_insert	=> p_update_change_insert);

Line: 233

  update  ghr_duty_stations_f t
  set	  t.effective_end_date	  = p_new_effective_end_date,
          t.object_version_number = l_object_version_number
  where	  t.duty_station_id	  = p_base_key_value
  and	  p_effective_date  between t.effective_start_date
                                and t.effective_end_date;

Line: 271

  SELECT duty_station_id,
	 effective_start_date,
	 effective_end_date,
         locality_pay_area_id,
         leo_pay_area_code,
         name             ,
         duty_station_code,
         msa_code         ,
         cmsa_code        ,
         state_or_country_code,
         county_code           ,
         is_duty_station    ,
	 object_version_number
   FROM  ghr_duty_stations_f
  WHERE  duty_station_id = p_duty_station_id
    AND  p_effective_date between effective_start_date
                                 and effective_end_date
    FOR UPDATE NOWAIT;

Line: 315

  If (p_datetrack_mode <> 'INSERT') then
    --
    -- We must select and lock the current row.
    --
    Open  C_Sel1;