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 4679: from ben_pl_f pl,

4675: -- enrt.pgm_id pgm_id,
4676: -- pgm.name pgm_name,
4677: pl.pl_typ_id pl_typ_id,
4678: ptp.name pl_typ_name
4679: from ben_pl_f pl,
4680: -- ben_oipl_f oipl,
4681: -- ben_opt_f opt,
4682: -- ben_pgm_f pgm,
4683: ben_pl_typ_f ptp