APPS.GHR_REI_BUS SQL Statements

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

Line: 47

      select 'x'
        from ghr_pa_requests
       where pa_request_id = p_pa_request_id;

Line: 111

Procedure chk_non_updateable_args(p_rec in ghr_rei_shd.g_rec_type) is
--
  l_proc        varchar2(72) := g_package||'chk_non_updateable_args';

Line: 155

end chk_non_updateable_args;

Line: 201

	SELECT	rit.multiple_occurrences_flag
			,rit.active_inactive_flag
	FROM		ghr_pa_request_info_types	rit
	WHERE		rit.information_type 		= p_information_type
	;

Line: 300

	SELECT	'x'
	FROM		ghr_pa_request_extra_info	rei
	WHERE		rei.information_type 		= p_information_type
	AND		rei.pa_request_id			= p_pa_request_id ;

Line: 561

    Select pei_information2
    From   per_people_extra_info
    Where  person_extra_info_id  =  p_rec.rei_information3;

Line: 566

    Select first_noa_code,effective_date
    From   ghr_pa_requests
    Where  pa_request_id = p_rec.pa_request_id;

Line: 635

    Select first_noa_code,effective_date,person_id
    From   ghr_pa_requests
    Where  pa_request_id = p_rec.pa_request_id;

Line: 673

Procedure insert_validate(p_rec in ghr_rei_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 687

  select par.person_id,nvl(par.from_position_id,par.to_position_id) position_id,
         par.effective_date
  from ghr_pa_requests  par
  where pa_request_id = p_rec.pa_request_id;

Line: 692

  select ppf.business_group_id
  from per_people_f ppf
  where ppf.person_id = p_person_id
  and l_effective_date between ppf.effective_start_date
  and ppf.effective_end_date;

Line: 698

  select pos.business_group_id
  from hr_all_positions_f pos  -- Venkat -- Position DT
  where pos.position_id = p_position_id
  and  l_effective_date  between pos.effective_start_date
  and pos.effective_end_date;

Line: 911

End insert_validate;

Line: 916

Procedure update_validate(p_rec in ghr_rei_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 929

  select par.person_id,nvl(par.from_position_id,par.to_position_id) position_id,
         par.effective_date
  from ghr_pa_requests  par
  where pa_request_id = p_rec.pa_request_id;

Line: 934

  select ppf.business_group_id
  from per_people_f ppf
  where ppf.person_id = p_person_id
  and l_effective_date between ppf.effective_start_date
  and ppf.effective_end_date;

Line: 940

  select pos.business_group_id
  from hr_all_positions_f pos  -- Venkat -- Position DT
  where pos.position_id = p_position_id
  and  l_effective_date  between pos.effective_start_date
  and pos.effective_end_date;

Line: 977

  chk_non_updateable_args (p_rec => p_rec);

Line: 1141

End update_validate;

Line: 1146

Procedure delete_validate(p_rec in ghr_rei_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 1156

End delete_validate;