APPS.BEN_USE_CVG_RT_DATE SQL Statements

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

Line: 52

   select /*+ first_rows(1) */ 'x'  -- 5095721
   from  ben_plip_f  plip
   where plip.pgm_id = p_pgm_id
     and plip.USE_CSD_RSD_PRCCNG_CD is not null
     and plip.plip_stat_cd = 'A'
     and p_effective_date between plip.effective_start_date
         and plip.effective_end_date
     and rownum = 1  -- 5095721
     ;

Line: 63

   select /*+ first_rows(1) */ 'x' -- 5095721
   from  ben_plip_f  plip, ben_ptip_f ptip, ben_pl_f pl
   where ptip.ptip_id  =  p_ptip_id
     and ptip.pgm_id   =  plip.pgm_id
     and plip.pl_id    =  pl.pl_id
     and pl.pl_typ_id  =  ptip.pl_typ_id
     and plip.USE_CSD_RSD_PRCCNG_CD is not null
     and plip.plip_stat_cd = 'A'
     and ptip.ptip_stat_cd = 'A'
     and p_effective_date between ptip.effective_start_date
         and ptip.effective_end_date
     and p_effective_date between pl.effective_start_date
         and pl.effective_end_date
     and p_effective_date between plip.effective_start_date
         and plip.effective_end_date
     and rownum = 1 -- 5095721
     ;

Line: 82

   select 'x'
   from  ben_plip_f  plip
   where plip.plip_id = p_plip_id
     and plip.USE_CSD_RSD_PRCCNG_CD is not null
     and plip.plip_stat_cd = 'A'
     and p_effective_date between plip.effective_start_date
         and plip.effective_end_date
     and rownum = 1; -- 5095721

Line: 93

   select 'x'
   from  ben_pl_f  pl
   where pl.pl_id = p_pl_id
     and pl.USE_CSD_RSD_PRCCNG_CD is not null
     and pl.pl_stat_cd = 'A'
     and p_effective_date between pl.effective_start_date
         and pl.effective_end_date
     and rownum = 1; -- 5095721

Line: 186

  ben_manage_life_events.g_cache_person_prtn.delete;