DBA Data[Home] [Help]

APPS.BEN_EPE_CACHE dependencies on BEN_PER_IN_LER

Line 173: ben_per_in_ler pil

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
177: AND epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id

Line 534: ben_per_in_ler pil

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
538: AND epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id

Line 924: ben_per_in_ler pil

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
928: AND epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id