APPS.BEN_EPE_CACHE dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 170: FROM ben_elig_per_elctbl_chc epe,

166: null,
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 (+)

Line 532: ben_elig_per_elctbl_chc epe,

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
536: AND epe.per_in_ler_id = pil.per_in_ler_id

Line 921: FROM ben_elig_per_elctbl_chc epe,

917: epe.bnft_prvdr_pool_id,
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 (+)

Line 1240: FROM ben_elig_per_elctbl_chc epe

1236: ,c_oipl_id number
1237: )
1238: is
1239: SELECT epe.elig_per_elctbl_chc_id
1240: FROM ben_elig_per_elctbl_chc epe
1241: WHERE epe.oipl_id = c_oipl_id
1242: AND epe.pgm_id = c_pgm_id
1243: AND epe.per_in_ler_id = c_per_in_ler_id;
1244: --

Line 1251: FROM ben_elig_per_elctbl_chc epe

1247: ,c_oipl_id number
1248: )
1249: is
1250: SELECT epe.elig_per_elctbl_chc_id
1251: FROM ben_elig_per_elctbl_chc epe
1252: WHERE epe.oipl_id = c_oipl_id
1253: AND epe.pgm_id IS NULL
1254: AND epe.per_in_ler_id = c_per_in_ler_id;
1255: --

Line 1263: FROM ben_elig_per_elctbl_chc epe

1259: ,c_pl_id number
1260: )
1261: is
1262: SELECT epe.elig_per_elctbl_chc_id
1263: FROM ben_elig_per_elctbl_chc epe
1264: WHERE epe.pl_id = c_pl_id
1265: AND epe.oipl_id IS NULL
1266: AND epe.pgm_id = c_pgm_id
1267: AND epe.per_in_ler_id = c_per_in_ler_id;

Line 1275: FROM ben_elig_per_elctbl_chc epe

1271: ,c_pl_id number
1272: )
1273: is
1274: SELECT epe.elig_per_elctbl_chc_id
1275: FROM ben_elig_per_elctbl_chc epe
1276: WHERE epe.pl_id = c_pl_id
1277: AND epe.oipl_id IS NULL
1278: AND epe.pgm_id IS NULL
1279: AND epe.per_in_ler_id = c_per_in_ler_id;