APPS.BEN_CWB_PL_DSGN_PKG dependencies on BEN_PL_F

Line 98: where exists(select null from ben_pl_f pl

94: -- in other plans)
95: begin
96: select null into l_dummy
97: from dual
98: where exists(select null from ben_pl_f pl
99: where pl.group_pl_id = p_pl_id
100: and pl.pl_id <> p_pl_id
101: and p_effective_date between pl.effective_start_date
102: and pl.effective_end_date);

Line 264: from ben_pl_f pl

260: ,enp.asg_updt_eff_date asg_updt_eff_date
261: ,enp.emp_interview_type_cd emp_interview_typ_cd
262: ,enp.sal_chg_reason_cd salary_change_reason
263: ,enp.data_freeze_date data_freeze_date
264: from ben_pl_f pl
265: ,ben_popl_enrt_typ_cycl_f petc
266: ,ben_enrt_perd enp
267: ,ben_yr_perd yr
268: ,ben_wthn_yr_perd wyr

Line 349: from ben_pl_f pl

345: 'A') pl_stat_cd
346: ,nvl(cur.precision, 2) uom_precision
347: ,enp.enrt_perd_id enrt_perd_id
348: ,enp.yr_perd_id yr_perd_id
349: from ben_pl_f pl
350: ,ben_acty_base_rt_f ws
351: ,ben_acty_base_rt_f db
352: ,ben_acty_base_rt_f wb
353: ,ben_acty_base_rt_f rsrv

Line 498: ,ben_pl_f pl

494: ,oc.rndg_cd oth_comp_rndg_cd
495: from ben_oipl_f oipl
496: ,ben_opt_f opt
497: ,ben_oipl_f group_oipl
498: ,ben_pl_f pl
499: ,ben_acty_base_rt_f ws
500: ,ben_acty_base_rt_f db
501: ,ben_acty_base_rt_f wb
502: ,ben_acty_base_rt_f rsrv