DBA Data[Home] [Help]

APPS.BEN_CWB_EMP_ELIG dependencies on BEN_CWB_PL_DSGN

Line 32: ben_cwb_pl_dsgn dsgn

28: IS
29: SELECT nvl(dsgn.wthn_yr_start_dt,dsgn.yr_perd_start_dt)||' - '||
30: nvl(dsgn.wthn_yr_end_dt,dsgn.yr_perd_end_dt) forPeriod
31: FROM ben_per_in_ler pil,
32: ben_cwb_pl_dsgn dsgn
33: WHERE pil.per_in_ler_id = p_group_per_in_ler_id
34: AND pil.group_pl_id = dsgn.group_pl_id
35: AND pil.lf_evt_ocrd_dt = dsgn.lf_evt_ocrd_dt
36: AND dsgn.oipl_id = -1