APPS.BEN_PPL_BUS SQL Statements

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

Line: 115

    select a.typ_cd
    from   ben_ler_f a
    where  a.ler_id = p_ler_id
    and    p_effective_date
           between a.effective_start_date
           and     a.effective_end_date;

Line: 224

   select null from ben_ptnl_ler_for_per
   where person_id = p_person_id
   and   ler_id = p_ler_id
   and   lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
   and   ptnl_ler_for_per_stat_cd = p_ptnl_ler_for_per_stat_cd
   and   ptnl_ler_for_per_stat_cd not in ('VOIDD', 'BCKDT')
   and   business_group_id = p_business_group_id;

Line: 298

    select null
    from   ben_ptnl_ler_for_per a
    where  a.ptnl_ler_for_per_id = p_csd_by_ptnl_ler_for_per_id;

Line: 374

    select null
    from   ben_enrt_perd a
    where  a.enrt_perd_id = p_enrt_perd_id;

Line: 456

    select ler.qualg_evt_flag
    from   ben_ler_f ler
    where  ler.ler_id = p_ler_id
    and    p_effective_date between ler.effective_start_date and ler.effective_end_date;

Line: 472

    select null
    from   per_all_people_f a
    where  a.person_id = l_person_id
    and    decode(l_cobra_flag, 'Y', p_effective_date, p_lf_evt_ocrd_dt)  /* Bug 5672925 + 5747460*/
           between a.effective_start_date
           and     a.effective_end_date;

Line: 480

    select contact_person_id
    from   per_contact_relationships a
    where  a.person_id = p_person_id
    and    decode(l_cobra_flag, 'Y', p_effective_date, p_lf_evt_ocrd_dt)  /* Bug 5672925 + 5747460*/
           between a.date_start
           and nvl(a.date_end,to_date('31-12-4712','DD-MM-YYYY'));

Line: 488

	select effective_start_date from per_all_people_f
	where person_id = p_person_id;

Line: 793

function chk_delete_allowed
  (p_ptnl_ler_for_per_id      in number,
   p_ptnl_ler_for_per_stat_cd in varchar2,
   p_business_group_id        in number,
   p_person_id                in number,
   p_ler_id                   in number,
   p_lf_evt_ocrd_dt           in date) return boolean is
  --
  cursor c1 is
    select null
    from   ben_per_in_ler pil
    where  pil.person_id = p_person_id
    and    pil.business_group_id+0 = p_business_group_id
    and    pil.ler_id = p_ler_id
    and    pil.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;

Line: 809

  l_proc         varchar2(72) := g_package||'chk_delete_allowed';

Line: 843

end chk_delete_allowed;

Line: 883

  l_proc         varchar2(72) := g_package||'chk_delete_allowed';

Line: 934

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

Line: 1009

End insert_validate;

Line: 1014

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

Line: 1087

End update_validate;

Line: 1092

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

Line: 1103

End delete_validate;

Line: 1116

    select a.legislation_code
    from   per_business_groups a,
           ben_ptnl_ler_for_per b
    where b.ptnl_ler_for_per_id      = p_ptnl_ler_for_per_id
    and   a.business_group_id = b.business_group_id;