APPS.BEN_PRV_BUS SQL Statements

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

Line: 112

    select null
    from   ben_prtt_enrt_rslt_f a
    where  a.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
    and    p_effective_date
           between a.effective_start_date
           and     a.effective_end_date;

Line: 192

    select null
    from   pay_element_entry_values_f a
    where  a.element_entry_value_id = p_element_entry_value_id
    and    p_effective_date
           between a.effective_start_date
           and     a.effective_end_date;

Line: 963

    select ecr.ann_mn_elcn_val, ecr.ann_mx_elcn_val, ecr.acty_base_rt_id,
           ecr.elig_per_elctbl_chc_id, ecr.enrt_bnft_id, ecr.object_version_number,
           ecr.entr_ann_val_flag, dsply_mn_elcn_val, dsply_mx_elcn_val,incrmt_elcn_val
      From ben_enrt_rt ecr
     where ecr.enrt_rt_id=p_enrt_rt_id;

Line: 971

    select enb.elig_per_elctbl_chc_id
    from   ben_enrt_bnft enb
    where  enb.enrt_bnft_id = p_enrt_bnft_id;

Line: 976

    select pil.person_id
    from   ben_elig_per_elctbl_chc epe, ben_per_in_ler pil
    where  epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
    and    epe.per_in_ler_id = pil.per_in_ler_id;

Line: 983

     select decode (ecr.elig_per_elctbl_chc_id ,
                null,
                enb.elig_per_elctbl_chc_id,
                ecr.elig_per_elctbl_chc_id
               )
     from   ben_enrt_rt ecr,
      	    ben_enrt_bnft enb
     where  ecr.enrt_rt_id = p_enrt_rt_id and
            enb.enrt_bnft_id(+) = ecr.enrt_bnft_id;

Line: 996

          select pln.name || ' '|| opt.name
     from   ben_elig_per_elctbl_chc epe,
            ben_pl_f                pln,
            ben_oipl_f              oipl,
            ben_opt_f               opt
     where  epe.elig_per_elctbl_chc_id =c_elig_per_elctbl_chc_id
     and    epe.pl_id                  = pln.pl_id
     and    epe.oipl_id                = oipl.oipl_id(+)
     and    oipl.opt_id                = opt.opt_id(+)
     and    p_effective_date between
            pln.effective_start_date and pln.effective_end_date
     and    p_effective_date between
            oipl.effective_start_date(+) and oipl.effective_end_date(+)
     and    p_effective_date between
            opt.effective_start_date(+) and opt.effective_end_date(+);

Line: 1015

    select abr.ann_mn_elcn_val, abr.ann_mx_elcn_val
      from ben_acty_base_rt_f abr
     where abr.acty_base_rt_id = c_acty_base_rt_id
       and p_effective_date between abr.effective_start_date
                                and abr.effective_end_date;

Line: 1113

            ben_enrollment_rate_api.update_enrollment_rate
              (p_VALIDATE              => false
              ,p_ENRT_RT_ID            => p_enrt_rt_id
              ,p_ANN_MN_ELCN_VAL       => l_ann_mn_elcn_val
              ,p_ANN_MX_ELCN_VAL       => l_ann_mx_elcn_val
              ,p_DSPLY_MN_ELCN_VAL     => l_c1.dsply_mn_elcn_val
              ,p_DSPLY_MX_ELCN_VAL     => l_c1.dsply_mx_elcn_val
              ,p_OBJECT_VERSION_NUMBER => l_c1.object_version_number
              ,p_EFFECTIVE_DATE        => p_EFFECTIVE_DATE);

Line: 1221

     select mn_elcn_val,
	mx_elcn_val,
	ann_mn_elcn_val,
	ann_mx_elcn_val,
	incrmt_elcn_val,
        acty_base_rt_id,
        rt_mlt_cd ,
        entr_val_at_enrt_flag,
        entr_ann_val_flag
     from ben_enrt_rt
	where enrt_rt_id=p_enrt_rt_id  ;

Line: 1235

      select use_calc_acty_bs_rt_flag
      from ben_acty_base_rt_f
      where  acty_base_rt_id = p_acty_base_rt_id
      and p_effective_date between effective_start_date and effective_end_date ;

Line: 1241

     select decode (ecr.elig_per_elctbl_chc_id ,
                    null,
                    enb.elig_per_elctbl_chc_id,
                    ecr.elig_per_elctbl_chc_id
                   )
    from ben_enrt_rt ecr,
         ben_enrt_bnft enb
    where ecr.enrt_rt_id = p_enrt_rt_id and
          enb.enrt_bnft_id (+) = ecr.enrt_bnft_id;

Line: 1254

   select pln.name || ' '|| opt.name
   from   ben_elig_per_elctbl_chc epe,
                ben_pl_f                pln,
                ben_oipl_f              oipl,
                ben_opt_f               opt
   where  epe.elig_per_elctbl_chc_id =c_elig_per_elctbl_chc_id
   and    epe.pl_id                  = pln.pl_id
   and    epe.oipl_id                = oipl.oipl_id(+)
   and    oipl.opt_id                = opt.opt_id(+)
   and    p_effective_date between
          pln.effective_start_date and pln.effective_end_date
   and    p_effective_date between
          oipl.effective_start_date(+) and oipl.effective_end_date(+)
   and    p_effective_date between
          opt.effective_start_date(+) and opt.effective_end_date(+);

Line: 1449

  select null
    from ben_acty_base_rt_f
   where acty_base_rt_id = p_acty_base_rt_id
     and p_effective_date between effective_start_date
     and effective_end_date;

Line: 1508

 select person_id
 from   ben_prtt_enrt_rslt_f pen
 where  pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id;

Line: 1539

Procedure insert_validate(p_rec in ben_prv_shd.g_rec_type,p_effective_date in date ) is

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

Line: 1668

End insert_validate;

Line: 1673

Procedure update_validate(p_rec in ben_prv_shd.g_rec_type,p_effective_date  in date) is

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

Line: 1800

End update_validate;

Line: 1805

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

Line: 1815

End delete_validate;

Line: 1827

    select a.legislation_code
    from   per_business_groups a,
           ben_prtt_rt_val b
    where b.prtt_rt_val_id      = p_prtt_rt_val_id
    and   a.business_group_id = b.business_group_id;