APPS.BEN_PERSON_RECORD dependencies on BEN_PRTT_ENRT_RSLT_F

Line 51: ben_prtt_enrt_rslt_f pen,

47: ppf.full_name dependent_full_name,
48: pdp.cvg_strt_dt,
49: to_date(null) cvg_thru_dt
50: from ben_elig_per_elctbl_chc epe,
51: ben_prtt_enrt_rslt_f pen,
52: ben_elig_cvrd_dpnt_f pdp,
53: per_contact_relationships pcr,
54: per_people_f ppf,
55: ben_pl_typ_f plt,

Line 148: ben_prtt_enrt_rslt_f pen,

144: pen.oipl_ordr_num oipl_ordr_num,
145: pen.bnft_ordr_num bnft_ordr_num
146: from per_people_f ppf,
147: per_contact_relationships pcr,
148: ben_prtt_enrt_rslt_f pen,
149: ben_pl_bnf_f pbn,
150: ben_pl_typ_f plt,
151: ben_pl_f pln,
152: hr_all_organization_units org,

Line 318: ben_prtt_enrt_rslt_f pen,

314: epe.pl_id,
315: epe.oipl_id
316: FROM ben_elig_per_elctbl_chc epe,
317: ben_enrt_bnft beb,
318: ben_prtt_enrt_rslt_f pen,
319: ben_pl_typ_f plt,
320: ben_pil_elctbl_chc_popl pel,
321: ben_prtt_enrt_rslt_f pen1,
322: ben_ler_f ler

Line 321: ben_prtt_enrt_rslt_f pen1,

317: ben_enrt_bnft beb,
318: ben_prtt_enrt_rslt_f pen,
319: ben_pl_typ_f plt,
320: ben_pil_elctbl_chc_popl pel,
321: ben_prtt_enrt_rslt_f pen1,
322: ben_ler_f ler
323: WHERE pen.prtt_enrt_rslt_id = pen1.rplcs_sspndd_rslt_id (+)
324: and ( p_effective_date) between pen1.effective_start_date (+)
325: and pen1.effective_end_date (+)

Line 388: ben_prtt_enrt_rslt_f pen,

384: epe.pl_id,
385: epe.oipl_id
386: FROM ben_elig_per_elctbl_chc epe,
387: ben_enrt_bnft beb,
388: ben_prtt_enrt_rslt_f pen,
389: ben_pl_typ_f plt,
390: ben_pil_elctbl_chc_popl pel,
391: ben_prtt_enrt_rslt_f pen1,
392: ben_ler_f ler

Line 391: ben_prtt_enrt_rslt_f pen1,

387: ben_enrt_bnft beb,
388: ben_prtt_enrt_rslt_f pen,
389: ben_pl_typ_f plt,
390: ben_pil_elctbl_chc_popl pel,
391: ben_prtt_enrt_rslt_f pen1,
392: ben_ler_f ler
393: WHERE pen.prtt_enrt_rslt_id = pen1.rplcs_sspndd_rslt_id (+)
394: and (p_effective_date) between pen1.effective_start_date (+)
395: and pen1.effective_end_date (+)