APPS.PER_PHN_BUS SQL Statements

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

Line: 14

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

Line: 72

end chk_non_updateable_args;

Line: 328

        select phn.phone_id
        from per_phones phn
        where phn.phone_type = 'H1'
        and phn.phone_id <> nvl(p_phone_id,hr_api.g_number)
        and (
             p_date_from between phn.date_from and
              nvl(phn.date_to,hr_api.g_eot)
            OR
             nvl(p_date_to,hr_api.g_eot) between phn.date_from and
              nvl(phn.date_to,hr_api.g_eot)
            OR
             phn.date_from between p_date_from and
              nvl(p_date_to,hr_api.g_eot)
            OR
             nvl(phn.date_to,hr_api.g_eot) between p_date_from and
              nvl(p_date_to,hr_api.g_eot)
             )
        and (
             (phn.parent_id = p_parent_id           --
             and phn.parent_table = p_parent_table) -- HR/TCA merge
            OR                                      --
             (phn.party_id = p_party_id and p_parent_id is null) -- 3299844
            );

Line: 354

        select phn.phone_id
        from per_phones phn
        where phn.phone_type = 'W1'
        and phn.phone_id <> nvl(p_phone_id,hr_api.g_number)
        and (
             p_date_from between phn.date_from and
              nvl(phn.date_to,hr_api.g_eot)
            OR
             nvl(p_date_to,hr_api.g_eot) between phn.date_from and
              nvl(phn.date_to,hr_api.g_eot)
            OR
             phn.date_from between p_date_from and
              nvl(p_date_to,hr_api.g_eot)
            OR
             nvl(phn.date_to,hr_api.g_eot) between p_date_from and
              nvl(p_date_to,hr_api.g_eot)
             )
        and (
             (phn.parent_id = p_parent_id              --
              and phn.parent_table = p_parent_table)   -- HR/TCA merge
            OR                                         --
              (phn.party_id = p_party_id and p_parent_id is null) -- 3299844
            );

Line: 581

    select per.person_id
    from per_all_people_f per
    where per.person_id = p_parent_id
    and rownum <2;  -- performance bug fix 3387297

Line: 715

  select party_id
  from    per_all_people_f per
    where   per.person_id = p_rec.parent_id
    and     p_effective_date
    between per.effective_start_date
    and     nvl(per.effective_end_date,hr_api.g_eot)
    and rownum <2; -- Performace bug fix #3387297

Line: 724

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

Line: 876

procedure df_update_validate
  (p_rec in per_phn_shd.g_rec_type) is
--
  l_proc    varchar2(72) := g_package||'df_update_validate';

Line: 955

end df_update_validate;

Line: 1204

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

Line: 1305

End insert_validate;

Line: 1310

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

Line: 1337

  chk_non_updateable_args (p_rec  => p_rec);

Line: 1408

End update_validate;

Line: 1413

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

Line: 1428

End delete_validate;

Line: 1441

    select pbg.legislation_code
      from per_business_groups  pbg
         , per_phones           phn
         , per_all_people_f     per
     where phn.phone_id         = p_phone_id
       and phn.parent_id        = per.person_id
       and pbg.business_group_id = per.business_group_id;