DBA Data[Home] [Help]

APPS.BEN_EPE_CACHE dependencies on BEN_ENRT_BNFT

Line 172: ben_enrt_bnft enb,

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
176: AND epe.per_in_ler_id = pel.per_in_ler_id

Line 531: FROM ben_enrt_bnft enb,

527: epe.bnft_prvdr_pool_id,
528: epe.elig_flag,
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

Line 923: ben_enrt_bnft enb,

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
927: AND epe.per_in_ler_id = pel.per_in_ler_id