APPS.PER_QUA_BUS SQL Statements

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

Line: 30

       select inf.org_information14
      from hr_organization_information inf
         , per_qualifications  qua
     where qua.qualification_id = p_qualification_id
       and inf.organization_id = qua.business_group_id
       and inf.org_information_context || '' = 'Business Group Information';

Line: 89

    select pbg.legislation_code
      from per_business_groups_perf pbg
         , per_qualifications qua
     where qua.qualification_id = p_qualification_id
       and pbg.business_group_id (+) = qua.business_group_id;

Line: 249

    select null
    from   per_qualification_types per
    where  per.qualification_type_id = p_qualification_type_id;

Line: 333

    select  null
    from    per_all_people_f per  -- Bug 3148893. Replaced per_all_people_f with per_people_f
    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);

Line: 341

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

Line: 481

  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: 489

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

Line: 494

  select party_id
        ,person_id
  from per_establishment_attendances pea
  where  pea.attendance_id = p_rec.attendance_id;

Line: 895

    select null
    from   fnd_currencies fnd
    where  fnd.currency_code = p_fee_currency;

Line: 1025

    select  null
    from    per_establishment_attendances per
    where   per.attendance_id = p_attendance_id
    and     nvl(p_start_date,nvl(per.attended_start_date,hr_api.g_sot))
    between nvl(per.attended_start_date,hr_api.g_sot)
    and     nvl(per.attended_end_date,hr_api.g_eot)
    and     nvl(p_end_date,nvl(per.attended_end_date,hr_api.g_eot))
    between nvl(per.attended_start_date,hr_api.g_sot)
    and     nvl(per.attended_end_date,hr_api.g_eot);

Line: 1039

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

Line: 1049

    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: 1228

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

Line: 1473

    select null
    from   per_establishment_attendances per
    where  per.attendance_id = p_attendance_id
    and    nvl(per.business_group_id,-1) = nvl(p_business_group_id,
                                       nvl(per.business_group_id,-1));

Line: 1581

    select  null
    from    per_all_people_f per  -- Bug 3148893. Replaced per_all_people_f with per_people_f
    where   per.person_id = p_person_id
    and     per.business_group_id +0 = nvl(p_business_group_id,
                                        per.business_group_id)
    and     p_effective_date
    between per.effective_start_date
    and     nvl(per.effective_end_date,hr_api.g_eot);

Line: 1688

Procedure chk_qualification_delete (p_qualification_id in number) is
  --
  l_proc         varchar2(72) := g_package||'chk_qualification_delete';

Line: 1695

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

Line: 1741

End chk_qualification_delete;

Line: 2087

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

Line: 2262

End insert_validate;

Line: 2267

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

Line: 2441

End update_validate;

Line: 2446

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

Line: 2458

  chk_qualification_delete(p_qualification_id => p_rec.qualification_id);

Line: 2461

End delete_validate;