DBA Data[Home] [Help]

APPS.BEN_EPE_CACHE dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 171: ben_pil_elctbl_chc_popl pel,

167: null,
168: null,
169: null */
170: FROM ben_elig_per_elctbl_chc epe,
171: ben_pil_elctbl_chc_popl pel,
172: ben_enrt_bnft enb,
173: ben_per_in_ler pil
174: WHERE epe.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id (+)
175: AND epe.per_in_ler_id = pil.per_in_ler_id

Line 533: ben_pil_elctbl_chc_popl pel,

529: epe.inelig_rsn_cd,
530: epe.fonm_cvg_strt_dt
531: FROM ben_enrt_bnft enb,
532: ben_elig_per_elctbl_chc epe,
533: ben_pil_elctbl_chc_popl pel,
534: ben_per_in_ler pil
535: WHERE enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
536: AND epe.per_in_ler_id = pil.per_in_ler_id
537: AND epe.per_in_ler_id = pel.per_in_ler_id

Line 922: ben_pil_elctbl_chc_popl pel,

918: epe.elig_flag,
919: epe.inelig_rsn_cd,
920: epe.fonm_cvg_strt_dt
921: FROM ben_elig_per_elctbl_chc epe,
922: ben_pil_elctbl_chc_popl pel,
923: ben_enrt_bnft enb,
924: ben_per_in_ler pil
925: WHERE epe.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id (+)
926: AND epe.per_in_ler_id = pil.per_in_ler_id