APPS.PER_SUB_BUS SQL Statements

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

Line: 108

    select null
    from   per_qualifications per
    where  per.qualification_id = p_qualification_id;

Line: 196

    select  null
    from    per_qualifications per
    where   per.qualification_id = p_qualification_id
    and     p_start_date between nvl(per.start_date,hr_api.g_sot)
        	and     nvl(per.end_date,p_start_date)
    and     (p_start_date <= nvl(per.end_date,hr_api.g_eot));

Line: 206

  select start_date,end_date
  into l_start_date,l_end_date
  from per_qualifications per
  where per.qualification_id = p_qualification_id;

Line: 321

    select  null
    from    per_qualifications per
    where   per.qualification_id = p_qualification_id
    and     nvl(p_end_date,nvl(per.end_date,hr_api.g_eot))
    between nvl(per.start_date,hr_api.g_sot)
    and     nvl(per.end_date,hr_api.g_eot);

Line: 331

  select end_date
  into l_end_date
  from per_qualifications per
  where per.qualification_id = p_qualification_id;

Line: 541

    select  null
    from    per_subjects_taken per
    where   per.qualification_id = p_qualification_id
    and     per.subject = p_subject
    and     (p_start_date
    between per.start_date
    and     nvl(per.end_date,hr_api.g_eot)
    or      p_end_date
    between per.start_date
    and     nvl(per.end_date,hr_api.g_eot))
    and     per.subjects_taken_id <> nvl(p_subjects_taken_id,-1);

Line: 888

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

Line: 995

End insert_validate;

Line: 1000

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

Line: 1104

End update_validate;

Line: 1109

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

Line: 1119

End delete_validate;