APPS.PER_VGR_BUS SQL Statements

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

Line: 54

	select gra.business_group_id
	from per_grades gra
	where gra.grade_id = p_grade_id;

Line: 152

      select null
      from  per_grades gra
      where gra.grade_id = p_grade_id
        and p_date_from between gra.date_from
                                           and nvl(gra.date_to, hr_api.g_eot);

Line: 159

     select null
     from per_jobs_v job
     where job.job_id = p_job_id
       and p_date_from >= job.date_from;

Line: 168

     select null
     from hr_positions_f pos
     where pos.position_id = p_position_id
       and p_date_from >= pos.date_effective
       and p_effective_date between pos.effective_start_date and pos.effective_end_date;

Line: 354

	select job.business_group_id
	from per_jobs_v job
	where job.job_id = p_job_id;

Line: 359

       select null
       from per_valid_grades vgr
       where vgr.job_id = p_job_id
       and vgr.grade_id = p_grade_id
-- Fix For Bug # 6983587 Starts
       and
       (
	(p_date_from between vgr.date_from and nvl(vgr.date_to,hr_api.g_eot)
	or
	p_date_to between vgr.date_from and nvl(vgr.date_to,hr_api.g_eot)
	)
	or
	(p_date_from < vgr.date_from and p_date_to > nvl(vgr.date_to,hr_api.g_eot))
	);

Line: 473

	select pos.business_group_id
	from hr_positions_f pos
	where pos.position_id = p_position_id
	and p_effective_date between pos.effective_start_date and pos.effective_end_date;

Line: 479

        select null
        from per_valid_grades vgr
        where vgr.position_id = p_position_id
        and vgr.grade_id = p_grade_id
	-- Fix For Bug # 7516458 Starts
        and
        (
	( p_date_from between vgr.date_from and nvl(vgr.date_to,hr_api.g_eot)
	or
	 p_date_to between vgr.date_from and nvl(vgr.date_to,hr_api.g_eot))
	or
	(p_date_from < vgr.date_from and p_date_to > nvl(vgr.date_to,hr_api.g_eot))
	);

Line: 601

      select null
      from  per_grades gra
      where gra.grade_id = p_grade_id
       and nvl(p_date_to, hr_api.g_eot) between gra.date_from
                                           and nvl(gra.date_to, hr_api.g_eot);

Line: 608

     select null
     from per_jobs_v job
     where job.job_id = p_job_id
      and nvl(p_date_to, hr_api.g_eot) <= nvl(job.date_to, hr_api.g_eot);

Line: 617

     select null
     from hr_positions_f pos
     where pos.position_id = p_position_id
      and nvl(p_date_to, hr_api.g_eot)  <= nvl(hr_general.get_position_date_end(p_position_id), hr_api.g_eot)
      and p_effective_date between pos.effective_start_date and pos.effective_end_date;

Line: 848

Procedure insert_validate(p_rec           in per_vgr_shd.g_rec_type,
			  p_effective_date in date) is   -- Added for Bug# 1760707
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 937

End insert_validate;

Line: 942

Procedure update_validate(p_rec            in per_vgr_shd.g_rec_type,
			  p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 993

End update_validate;

Line: 998

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

Line: 1008

End delete_validate;

Line: 1021

    select pbg.legislation_code
      from per_business_groups  pbg
         , per_valid_grades pvg
     where pvg.valid_grade_id = p_valid_grade_id
       and pbg.business_group_id = pvg.business_group_id;