APPS.PER_QAT_BUS SQL Statements

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

Line: 62

    select pbg.legislation_code
      from per_business_groups pbg
         , per_qualifications_tl qat
         , per_qualifications qau
     where qat.qualification_id  = p_qualification_id
       and pbg.business_group_id = qau.business_group_id
       and qau.qualification_id  = qat.qualification_id;

Line: 156

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

Line: 178

End chk_non_updateable_args;

Line: 207

    select null
    from   per_qualifications per
          ,per_qualifications_tl qat
    where  qat.language                  = p_language
    and    qat.title                     = p_title
    and    qat.qualification_id          = per.qualification_id
    and    per.qualification_type_id     = p_qualification_type_id
    and    nvl(per.person_id,-1)         = nvl(p_person_id,-1)
    and    nvl(per.party_id,-1)          = nvl(p_party_id,nvl(per.party_id,-1)) --HR/TCA merge
    and    nvl(per.attendance_id,-1)     = nvl(p_attendance_id,-1)
    and    nvl(per.business_group_id,-1) = nvl(p_business_group_id,
                                           nvl(per.business_group_id,-1))
    and    per.qualification_id         <> NVL(p_qualification_id,-1)
    and    (nvl(per.start_date,hr_api.g_sot)
    between nvl(p_start_date,hr_api.g_sot)
    and     nvl(p_end_date,hr_api.g_eot)
   ---modified below condition for fixing bug#7571790
    --or      nvl(per.end_date,nvl(per.start_date,p_start_date))
    or      nvl(per.end_date,hr_api.g_eot)
    between nvl(p_start_date,hr_api.g_sot)
    and     nvl(p_end_date,hr_api.g_eot));

Line: 332

    select qau.qualification_type_id
          ,qau.person_id
          ,qau.attendance_id
          ,qau.business_group_id
          ,qau.object_version_number
          ,qau.start_date
          ,qau.end_date
          ,qau.party_id
      from per_qualifications qau
     where qau.qualification_id  = NVL(p_rec.qualification_id, p_qualification_id);

Line: 376

Procedure insert_validate
  (p_rec                          in per_qat_shd.g_rec_type
  ,p_qualification_id             in number
  ) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 395

End insert_validate;

Line: 400

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

Line: 416

  chk_non_updateable_args
    (p_rec              => p_rec
    );

Line: 425

End update_validate;

Line: 430

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

Line: 442

End delete_validate;