DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on BEN_PL_F

Line 1388: ,ben_pl_f pl

1384: , sum(bpl.used_val) credit_used
1385: from ben_prtt_enrt_rslt_f pen
1386: ,ben_per_in_ler pil
1387: ,ben_bnft_prvdd_ldgr_f bpl
1388: ,ben_pl_f pl
1389: where
1390: pen.person_id = p_person_id
1391: and pen.prtt_enrt_rslt_id = bpl.prtt_enrt_rslt_id
1392: and p_effective_date between nvl(pen.effective_start_date, p_effective_date)

Line 4714: from ben_pl_f pl,

4710: -- enrt.pgm_id pgm_id,
4711: -- pgm.name pgm_name,
4712: pl.pl_typ_id pl_typ_id,
4713: ptp.name pl_typ_name
4714: from ben_pl_f pl,
4715: -- ben_oipl_f oipl,
4716: -- ben_opt_f opt,
4717: -- ben_pgm_f pgm,
4718: ben_pl_typ_f ptp