APPS.PER_ESA_BUS SQL Statements

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

Line: 127

    select null
    from   per_establishment_attendances per
    where  nvl(per.person_id,-1) = nvl(p_person_id,-1)
    and    per.attended_start_date = nvl(p_attended_start_date,hr_api.g_sot)
    and    nvl(per.establishment_id,-1) = nvl(p_establishment_id,-1)
    and    nvl(per.establishment,-1) = nvl(p_establishment,-1)
    and    nvl(per.business_group_id,-1) = nvl(p_business_group_id,-1);

Line: 136

    select null
    from   per_establishment_attendances per
    where  per.party_id = p_party_id
    and    per.attended_start_date = nvl(p_attended_start_date,hr_api.g_sot)
    and    nvl(per.establishment_id,-1) = nvl(p_establishment_id,-1)
    and    nvl(per.establishment,-1) = nvl(p_establishment,-1);

Line: 287

  select party_id
  from    per_all_people_f per
    where   per.person_id = p_rec.person_id
    and     p_effective_date
    between per.effective_start_date
    and     nvl(per.effective_end_date,hr_api.g_eot);

Line: 295

  select party_id
  from hz_parties hzp
  where hzp.party_id = p_rec.party_id;

Line: 404

 	fnd_message.set_name('PER', 'HR_289587_ESA_ADDRESS_UPDATE');

Line: 544

    select null
    from   per_establishments per
    where  per.establishment_id = p_establishment_id;

Line: 671

    select  null
    from    per_establishment_attendances per
    where   per.person_id = p_person_id
    and     per.establishment_id = p_establishment_id
    and     per.attendance_id <> nvl(p_attendance_id,-1)
    and     (nvl(p_attended_start_date,hr_api.g_sot)
            between per.attended_start_date
            and     nvl(per.attended_end_date,hr_api.g_eot)
	    or      nvl(p_attended_end_date,hr_api.g_eot)
	    between per.attended_start_date
	    and     nvl(per.attended_end_date,hr_api.g_eot));

Line: 684

    select null
    from   per_qualifications per
    where  per.attendance_id = p_attendance_id
    and    (per.start_date
            not    between nvl(p_attended_start_date,hr_api.g_sot)
		   and     nvl(p_attended_end_date,per.start_date)
	    or per.end_date
            not    between nvl(p_attended_start_date,hr_api.g_sot)
		   and     nvl(p_attended_end_date,per.end_date));

Line: 696

    select  null
    from    per_establishment_attendances per
    where   per.party_id = p_party_id
    and     per.establishment_id = p_establishment_id
    and     per.attendance_id <> nvl(p_attendance_id,-1)
    and     (nvl(p_attended_start_date,hr_api.g_sot)
            between per.attended_start_date
            and     nvl(per.attended_end_date,hr_api.g_eot)
	    or nvl(p_attended_end_date,hr_api.g_eot)
	    between per.attended_start_date
	    and     nvl(per.attended_end_date,hr_api.g_eot));

Line: 711

    select  DATE_OF_BIRTH
    from    per_all_people_f per
    where   per.person_id = p_person_id
    and     p_effective_date
    between per.effective_start_date
    and     nvl(per.effective_end_date,hr_api.g_eot)
    and     date_of_birth is not null;

Line: 942

    select  null
    from    per_people_f per
    where   per.person_id = p_person_id
    and     per.business_group_id =nvl(p_business_group_id,per.business_group_id)
    and     trunc(p_effective_date)
    between trunc(per.effective_start_date)
    and     nvl(trunc(per.effective_end_date),trunc(per.effective_end_date));

Line: 1027

Procedure chk_estab_att_delete(p_attendance_id               in number,
		               p_object_version_number       in number) is
  --
  l_proc         varchar2(72) := g_package||'chk_estab_att_delete';

Line: 1035

    select  null
    from    per_qualifications per
    where   per.attendance_id = p_attendance_id;

Line: 1062

end chk_estab_att_delete;

Line: 1203

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

Line: 1316

End insert_validate;

Line: 1321

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

Line: 1424

End update_validate;

Line: 1429

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

Line: 1441

  chk_estab_att_delete(p_rec.attendance_id,
		       p_rec.object_version_number);

Line: 1445

End delete_validate;

Line: 1458

    select pbg.legislation_code
      from per_business_groups  pbg
         , per_establishment_attendances esa
     where esa.attendance_id = p_attendance_id
       and pbg.business_group_id = esa.business_group_id;

Line: 1467

    select 'Y'
      from per_establishment_attendances
     where attendance_id = p_attendance_id
       and business_group_id is null;