DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 1788: ben_pil_elctbl_chc_popl pel,

1784: FROM ben_elig_per_elctbl_chc epe,
1785: ben_enrt_bnft beb,
1786: ben_prtt_enrt_rslt_f pen,
1787: ben_pl_typ_f plt,
1788: ben_pil_elctbl_chc_popl pel,
1789: ben_prtt_enrt_rslt_f pen1,
1790: ben_ler_f ler
1791: WHERE pen.prtt_enrt_rslt_id = pen1.rplcs_sspndd_rslt_id (+)
1792: and ( p_effective_date) between pen1.effective_start_date (+)

Line 1858: ben_pil_elctbl_chc_popl pel,

1854: FROM ben_elig_per_elctbl_chc epe,
1855: ben_enrt_bnft beb,
1856: ben_prtt_enrt_rslt_f pen,
1857: ben_pl_typ_f plt,
1858: ben_pil_elctbl_chc_popl pel,
1859: ben_prtt_enrt_rslt_f pen1,
1860: ben_ler_f ler
1861: WHERE pen.prtt_enrt_rslt_id = pen1.rplcs_sspndd_rslt_id (+)
1862: and (p_effective_date) between pen1.effective_start_date (+)