APPS.BEN_CWB_RSGN_EMP dependencies on BEN_CWB_PL_DSGN

Line 57: ben_cwb_pl_dsgn dsgn

53: IS
54: SELECT nvl(dsgn.wthn_yr_start_dt,dsgn.yr_perd_start_dt)||' - '||
55: nvl(dsgn.wthn_yr_end_dt,dsgn.yr_perd_end_dt) forPeriod
56: FROM ben_per_in_ler pil,
57: ben_cwb_pl_dsgn dsgn
58: WHERE pil.per_in_ler_id = p_group_per_in_ler_id
59: AND pil.group_pl_id = dsgn.group_pl_id
60: AND pil.lf_evt_ocrd_dt = dsgn.lf_evt_ocrd_dt
61: AND dsgn.oipl_id = -1