APPS.BEN_DET_ENRT_RATES dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 174: ben_elig_per_elctbl_chc epe

170: and pen.effective_end_date = hr_api.g_eot
171: and -- start 4354929
172: ( EXISTS ( select null
173: from ben_ler_f ler,
174: ben_elig_per_elctbl_chc epe
175: where ler.ler_id = pen.ler_id
176: and (( ler.typ_cd = 'SCHEDDU'
177: and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
178: and epe.per_in_ler_id = c_per_in_ler_id )

Line 250: from ben_elig_per_elctbl_chc epe,

246: epe.spcl_rt_pl_id,
247: epe.spcl_rt_oipl_id,
248: epe.fonm_cvg_strt_dt,
249: pel.acty_ref_perd_cd
250: from ben_elig_per_elctbl_chc epe,
251: ben_per_in_ler pil,
252: ben_pil_elctbl_chc_popl pel,
253: ben_prtt_enrt_rslt_f pen
254: where epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id

Line 396: ben_elig_per_elctbl_chc epe,

392: pen.pgm_id,
393: pen.pl_id,
394: pen.oipl_id
395: from ben_per_in_ler pil,
396: ben_elig_per_elctbl_chc epe,
397: ben_pil_elctbl_chc_popl pel,
398: ben_enrt_rt ecr1,
399: ben_enrt_rt ecr2,
400: ben_enrt_bnft enb,

Line 924: ben_elig_per_elctbl_chc epe

920: and pen.effective_end_date = hr_api.g_eot
921: and -- start 4354929
922: ( EXISTS ( select null
923: from ben_ler_f ler,
924: ben_elig_per_elctbl_chc epe
925: where ler.ler_id = pen.ler_id
926: and (
927: ( ler.typ_cd = 'SCHEDDU'
928: and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id

Line 957: from ben_elig_per_elctbl_chc epe,

953: epe.elig_per_elctbl_chc_id,
954: epe.spcl_rt_pl_id,
955: epe.spcl_rt_oipl_id,
956: pel.acty_ref_perd_cd
957: from ben_elig_per_elctbl_chc epe,
958: ben_pil_elctbl_chc_popl pel,
959: ben_prtt_enrt_rslt_f pen
960: where epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
961: and epe.per_in_ler_id = p_per_in_ler_id

Line 995: from ben_elig_per_elctbl_chc epe

991: and ecr.acty_base_rt_id = c_acty_base_rt_id;
992: --
993: cursor c_prtt_enrt (p_pgm_id number) is
994: select prtt_enrt_rslt_id
995: from ben_elig_per_elctbl_chc epe
996: where epe.per_in_ler_id = p_per_in_ler_id
997: and epe.comp_lvl_cd = 'PLANFC'
998: and epe.pgm_id = p_pgm_id
999: and epe.business_group_id = p_business_group_id;

Line 1242: from ben_elig_per_elctbl_chc epe,

1238: epe.elig_per_elctbl_chc_id,
1239: epe.spcl_rt_pl_id,
1240: epe.spcl_rt_oipl_id,
1241: pel.acty_ref_perd_cd
1242: from ben_elig_per_elctbl_chc epe,
1243: ben_pil_elctbl_chc_popl pel,
1244: ben_prtt_enrt_rslt_f pen
1245: where epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
1246: and epe.per_in_ler_id = p_per_in_ler_id

Line 1285: from ben_elig_per_elctbl_chc epe

1281: and pen.prtt_enrt_rslt_stat_cd is null;
1282: --
1283: cursor c_prtt_enrt (p_pgm_id number) is
1284: select prtt_enrt_rslt_id
1285: from ben_elig_per_elctbl_chc epe
1286: where epe.per_in_ler_id = p_per_in_ler_id
1287: and epe.comp_lvl_cd = 'PLANFC'
1288: and epe.pgm_id = p_pgm_id
1289: and epe.business_group_id = p_business_group_id;