APPS.BEN_ENP_BUS SQL Statements

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

Line: 112

    select null
    from   ben_popl_enrt_typ_cycl_f a
    where  a.popl_enrt_typ_cycl_id = p_popl_enrt_typ_cycl_id
    and    p_effective_date
           between a.effective_start_date
           and     a.effective_end_date;

Line: 194

    select null
    from   ben_yr_perd a
    where  a.yr_perd_id = p_yr_perd_id;

Line: 200

     select null
        from ben_enrt_perd
        where yr_perd_id = p_yr_perd_id
          and enrt_perd_id <> nvl(p_enrt_perd_id, hr_api.g_number)
          and popl_enrt_typ_cycl_id = p_popl_enrt_typ_cycl_id
          and business_group_id + 0 = p_business_group_id;

Line: 387

    select null
    from ben_enrt_perd enp
    where enp.popl_enrt_typ_cycl_id = p_popl_enrt_typ_cycl_id
      and enp.enrt_perd_id <> nvl(p_enrt_perd_id, hr_api.g_number)
      and enp.asnd_lf_evt_dt = p_asnd_lf_evt_dt
      and enp.business_group_id = p_business_group_id ;

Line: 547

    select null
    from   ff_formulas_f ff ,
           per_business_groups pbg
    where  ff.formula_id = p_rt_end_dt_rl
    and    ff.formula_type_id = -67 /*default enrollment det */
    and    pbg.business_group_id = p_business_group_id
    and    nvl(ff.business_group_id, p_business_group_id) =
           p_business_group_id
    and    nvl(ff.legislation_code, pbg.legislation_code) =
           pbg.legislation_code
    and    p_effective_date
           between ff.effective_start_date
           and     ff.effective_end_date;

Line: 927

    select null
    from   ff_formulas_f ff ,
           per_business_groups pbg
    where  ff.formula_id = p_enrt_cvg_end_dt_rl
    and    ff.formula_type_id = -30 /*default enrollment det */
    and    pbg.business_group_id = p_business_group_id
    and    nvl(ff.business_group_id, p_business_group_id) =
           p_business_group_id
    and    nvl(ff.legislation_code, pbg.legislation_code) =
           pbg.legislation_code
    and    p_effective_date
           between ff.effective_start_date
           and     ff.effective_end_date;

Line: 1021

    select null
    from   ff_formulas_f ff ,
           per_business_groups pbg
    where  ff.formula_id = p_enrt_cvg_strt_dt_rl
    and    ff.formula_type_id = -29 /*default enrollment det */
    and    pbg.business_group_id = p_business_group_id
    and    nvl(ff.business_group_id, p_business_group_id) =
           p_business_group_id
    and    nvl(ff.legislation_code, pbg.legislation_code) =
           pbg.legislation_code
    and    p_effective_date
           between ff.effective_start_date
           and     ff.effective_end_date;

Line: 1183

    select null
    from   ff_formulas_f ff
           ,per_business_groups pbg
    where  ff.formula_id = p_rt_strt_dt_rl
    and    ff.formula_type_id = -66
    and    pbg.business_group_id = p_business_group_id
    and    nvl(ff.business_group_id, p_business_group_id) =
            p_business_group_id
    and    nvl(ff.legislation_code, pbg.legislation_code) =
            pbg.legislation_code
    and    p_effective_date
           between ff.effective_start_date
           and     ff.effective_end_date;

Line: 1474

  select   'x'
  from ame_transaction_types_v ame
  where  ame.transaction_type_id = p_hrchy_ame_trn_cd
    and  ame.fnd_application_id  = p_hrchy_ame_app_id ;

Line: 1484

    select 'x'
    from   ff_formulas_f ff ,
           per_business_groups pbg
    where  ff.formula_id = p_hrchy_rl
    and    ff.formula_type_id = -550 /*default enrollment det */
    and    nvl(ff.legislation_code, pbg.legislation_code) =  pbg.legislation_code
    and    p_effective_date between ff.effective_start_date and ff.effective_end_date;

Line: 2263

     select pln.pl_cd
     from   ben_pl_f pln
  	   ,ben_popl_enrt_typ_cycl_f pet
 	   ,ben_enrt_perd enp
    where   pet.popl_enrt_typ_cycl_id =  p_popl_enrt_typ_cycl_id
     and    pet.pl_id = pln.pl_id
     and    pln.business_group_id = p_business_group_id
     and    pet.business_group_id = pln.business_group_id
     and    p_effective_date between pln.effective_start_date and pln.effective_end_date
     and    p_effective_date between pet.effective_start_date and pet.effective_end_date;

Line: 2379

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

Line: 2587

end insert_validate;

Line: 2591

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

Line: 2799

End update_validate;

Line: 2804

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

Line: 2815

End delete_validate;

Line: 2828

    select a.legislation_code
    from   per_business_groups a,
           ben_enrt_perd b
    where b.enrt_perd_id      = p_enrt_perd_id
    and   a.business_group_id = b.business_group_id;