APPS.BEN_GLOBAL_FUNCTIONS SQL Statements

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

Line: 35

    select null
    from ben_pl_f pln
    where pln.pl_id = c_pl_id
    and not exists
      (select null
       from ben_plip_f cpp
       where pln.pl_id = cpp.pl_id);

Line: 47

    select null
    from ben_oipl_f cop
    where cop.oipl_id = c_oipl_id
    and not exists
      (select null
       from ben_plip_f cpp
       where cop.pl_id = cpp.pl_id);

Line: 106

    select pln.pl_id
    from ben_pl_f pln
    where pln.pl_id = c_pl_id
    and not exists
      (select null
       from ben_plip_f cpp
       where pln.pl_id = cpp.pl_id);

Line: 118

    select cop.pl_id
    from ben_oipl_f cop
    where cop.oipl_id = c_oipl_id
    and not exists
      (select null
       from ben_plip_f cpp
       where cop.pl_id = cpp.pl_id);

Line: 130

    select pl_id
    from ben_oipl_f cop
    where cop.opt_id = c_opt_id
    and not exists
      (select null
       from ben_plip_f
       where cop.pl_id = cop.pl_id)
    order by pl_id;

Line: 191

    select cpp.pgm_id
    from ben_oipl_f cop,
         ben_plip_f cpp
    where cop.oipl_id = c_oipl_id
    and   cop.pl_id   = cpp.pl_id;

Line: 201

    select cpp.pgm_id
    from ben_oiplip_f opp,
         ben_plip_f cpp
    where opp.oiplip_id = c_oiplip_id
    and   opp.plip_id   = cpp.plip_id;

Line: 211

    select cpp.pgm_id
    from ben_plip_f cpp
    where cpp.pl_id = c_pl_id;

Line: 219

    select cpp.pgm_id
    from ben_plip_f cpp
    where cpp.plip_id = c_plip_id;

Line: 227

    select cpp.pgm_id
    from ben_ptip_f cpp
    where cpp.ptip_id = c_ptip_id;

Line: 235

     select cpp.pgm_id
     from ben_oipl_f cop,
          ben_plip_f cpp
     where cop.opt_id = c_opt_id
     and cpp.pl_id = cop.pl_id
     order by cop.oipl_id, cpp.pl_id;

Line: 316

    select null
    from ben_acty_base_rt_f abr
    where abr.acty_base_rt_id = c_abr_id
    and nnmntry_uom is null;

Line: 357

    select abr.pgm_id,
           abr.ptip_id,
           abr.pl_id,
           abr.plip_id,
           abr.oipl_id,
           abr.oiplip_id
    from ben_acty_base_rt_f abr
    where abr.acty_base_rt_id = c_abr_id;

Line: 407

    select abr.pgm_id,
           abr.ptip_id,
           abr.pl_id,
           abr.plip_id,
           abr.oipl_id,
           abr.oiplip_id
    from ben_acty_base_rt_f abr
    where abr.acty_base_rt_id = c_abr_id;

Line: 453

    select ecr.acty_base_rt_id
    from ben_enrt_rt ecr
    where ecr.enrt_rt_id = c_ecr_id;

Line: 491

  select ben_global_functions.get_par_pgm_id
           (abr.pgm_id,abr.ptip_id,abr.pl_id,abr.plip_id,abr.oipl_id,abr.oiplip_id,abr.opt_id) pgm_id,
         ben_global_functions.get_par_plnip_id(abr.pl_id,abr.oipl_id,abr.opt_id) nip_id
  from ben_acty_vrbl_rt_f avr
     , ben_acty_base_rt_f abr
  where avr.vrbl_rt_prfl_id = p_vpf_id
  and avr.acty_base_rt_id = abr.acty_base_rt_id
  and abr.nnmntry_uom is null
  and avr.effective_start_date between abr.effective_start_date
                                   and abr.effective_end_date;

Line: 503

 select ben_global_functions.get_par_pgm_id
         (null,null,ccm.pl_id,ccm.plip_id,ccm.oipl_id,null) pgm_id,
        ben_global_functions.get_par_plnip_id(ccm.pl_id,ccm.oipl_id) nip_id
 from ben_bnft_vrbl_rt_f bvr
    , ben_cvg_amt_calc_mthd_f ccm
 where bvr.vrbl_rt_prfl_id = p_vpf_id
 and bvr.cvg_amt_calc_mthd_id = ccm.cvg_amt_calc_mthd_id
 and bvr.effective_start_date between ccm.effective_start_date
                                  and ccm.effective_end_date;

Line: 514

 select ben_global_functions.get_par_pgm_id
        (null,null,apr.pl_id,null,apr.oipl_id,null) pgm_id,
        ben_global_functions.get_par_plnip_id(apr.pl_id,apr.oipl_id) pl_id
 from ben_actl_prem_vrbl_rt_f apv
    , ben_actl_prem_f apr
 where apv.vrbl_rt_prfl_id = p_vpf_id
 and apv.actl_prem_id = apr.actl_prem_id
 and apv.effective_start_date between apr.effective_start_date
                                  and apr.effective_end_date;

Line: 577

    select ecr.acty_base_rt_id
    from ben_enrt_rt ecr
    where ecr.enrt_rt_id = c_ecr_id;