[Home] [Help]
45: ben_cwb_pl_dsgn dsgn
46: ,ben_cwb_person_rates rates
47: ,ben_popl_enrt_typ_cycl_f popl
48: ,ben_cwb_person_info info
49: ,ben_enrt_perd enrt
50: where dsgn.group_pl_id = p_group_pl_id
51: and dsgn.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
52: and info.group_per_in_ler_id = rates.group_per_in_ler_id
53: and nvl(info.post_process_stat_cd,'N') <> 'PR'