APPS.BEN_EXT_CWB SQL Statements

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

Line: 106

 select
     cwg.GROUP_PL_ID,
     cwg.GROUP_OIPL_ID,
     cwg.LF_EVT_OCRD_DT,
     cwg.ACCESS_CD,
     cwg.APPROVAL_CD,
     cwg.APPROVAL_DATE,
     cwg.DIST_BDGT_VAL,
     cwg.DUE_DT,
     pl.name pl_name ,
     --oipl.name opt_name ,
     cwg.LAST_UPDATED_BY,
     cwg.LAST_UPDATE_DATE,
     cwg.BDGT_POP_CD,
     cwg.RSRV_MX_VAL,
     cwg.RSRV_MN_VAL,
     cwg.RSRV_VAL,
     cwg.RSRV_VAL_LAST_UPD_BY,
     cwg.RSRV_VAL_LAST_UPD_DATE,
     cwg.SUBMIT_DATE,
     cwg.SUBMIT_CD,
     cwg.WS_BDGT_VAL,
     cwg.DFLT_DIST_BDGT_VAL,
     cwg.DIST_BDGT_ISS_DATE,
     cwg.DIST_BDGT_ISS_VAL,
     cwg.DIST_BDGT_MX_VAL,
     cwg.DIST_BDGT_MN_VAL,
     cwg.DIST_BDGT_VAL_LAST_UPD_BY,
     cwg.DIST_BDGT_VAL_LAST_UPD_DATE,
     cwg.WS_BDGT_ISS_DATE,
     cwg.WS_BDGT_ISS_VAL,
     cwg.WS_BDGT_MN_VAL,
     cwg.WS_BDGT_MX_VAL,
     cwg.WS_BDGT_VAL_LAST_UPD_DATE ,
     cwg.WS_BDGT_VAL_LAST_UPD_BY
 from BEN_CWB_PERSON_GROUPS cwg ,
      ben_cwb_pl_dsgn  pl
  --    ben_cwb_pl_dsgn  oipl
 where GROUP_PER_IN_LER_ID = p_per_in_ler_id
 and   pl.pl_id = cwg.GROUP_PL_ID
 and   pl.oipl_id = -1                    --- for the plan record oipl is -1
 and   cwg.lf_evt_ocrd_dt  =   pl.lf_evt_ocrd_dt
 --and   oipl.oipl_id = cwg.GROUP_OIPL_ID
 --and   oipl.pl_id = cwg.GROUP_PL_ID
 --and   cwg.lf_evt_ocrd_dt  =   oipl.lf_evt_ocrd_dt

 ;

Line: 158

 select  name
   from  ben_cwb_pl_dsgn
  where  pl_id      =  l_pl_id
    and  oipl_id    =  l_oipl_id
    and  lf_evt_ocrd_dt = l_date
 ;

Line: 182

     ben_ext_person.g_CWB_Budget_Last_Updt_By             :=  l_cwg.LAST_UPDATED_BY ;

Line: 183

     ben_ext_person.g_CWB_Budget_Last_Updt_dt             :=  l_cwg.LAST_UPDATE_DATE ;

Line: 250

 select
       cpr.Group_pl_id,
       cpr.pl_id ,
       cpr.group_oipl_id,
       cpr.oipl_id ,
       pl1.name group_pl_name,
       pl2.name Pl_name ,
       cpr.ELIG_FLAG  ,
       cpr.ELIG_SAL_VAL  ,
       cpr.MISC1_VAL  ,
       cpr.MISC2_VAL  ,
       cpr.MISC3_VAL  ,
       cpr.OTH_COMP_VAL  ,
       cpr.REC_VAL  ,
       cpr.STAT_SAL_VAL  ,
       cpr.TOT_COMP_VAL  ,
       cpr.WS_MN_VAL  ,
       cpr.WS_MX_VAL  ,
       cpr.WS_VAL     ,
       cpr.lf_evt_ocrd_dt
 From
   ben_cwb_person_rates cpr  ,
   ben_cwb_pl_dsgn  pl1 ,
   ben_cwb_pl_dsgn  pl2
 where
   cpr.group_per_in_ler_id  =   p_per_in_ler_id
   and cpr.group_pl_id   = pl1.pl_id
   and pl1.oipl_id       = -1
   and cpr.lf_evt_ocrd_dt =  pl1.lf_evt_ocrd_dt
   and cpr.group_pl_id   = pl2.pl_id
   and pl2.oipl_id       = -1
   and cpr.lf_evt_ocrd_dt =  pl2.lf_evt_ocrd_dt
;

Line: 287

 select oipl.name
 from   ben_cwb_pl_dsgn  oipl
 where oipl.oipl_id = p_oipl_id
   and oipl.pl_id   = p_pl_id
   and p_lf_evt_ocrd_dt  = oipl.lf_evt_ocrd_dt
 ;