DBA Data[Home] [Help]

APPS.BEN_CWB_RSGN_EMP dependencies on BEN_CWB_PL_DSGN

Line 56: ben_cwb_pl_dsgn dsgn

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