APPS.BEN_DET_ENRT_RATES dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 130: ben_elig_per_elctbl_chc epe

126: and pen.effective_end_date = hr_api.g_eot
127: and -- start 4354929
128: ( EXISTS ( select null
129: from ben_ler_f ler,
130: ben_elig_per_elctbl_chc epe
131: where ler.ler_id = pen.ler_id
132: and (( ler.typ_cd = 'SCHEDDU'
133: and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
134: and epe.per_in_ler_id = c_per_in_ler_id )

Line 206: from ben_elig_per_elctbl_chc epe,

202: epe.spcl_rt_pl_id,
203: epe.spcl_rt_oipl_id,
204: epe.fonm_cvg_strt_dt,
205: pel.acty_ref_perd_cd
206: from ben_elig_per_elctbl_chc epe,
207: ben_per_in_ler pil,
208: ben_pil_elctbl_chc_popl pel,
209: ben_prtt_enrt_rslt_f pen
210: where epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id

Line 352: ben_elig_per_elctbl_chc epe,

348: pen.pgm_id,
349: pen.pl_id,
350: pen.oipl_id
351: from ben_per_in_ler pil,
352: ben_elig_per_elctbl_chc epe,
353: ben_pil_elctbl_chc_popl pel,
354: ben_enrt_rt ecr1,
355: ben_enrt_rt ecr2,
356: ben_enrt_bnft enb,

Line 859: ben_elig_per_elctbl_chc epe

855: and pen.effective_end_date = hr_api.g_eot
856: and -- start 4354929
857: ( EXISTS ( select null
858: from ben_ler_f ler,
859: ben_elig_per_elctbl_chc epe
860: where ler.ler_id = pen.ler_id
861: and (
862: ( ler.typ_cd = 'SCHEDDU'
863: and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id

Line 892: from ben_elig_per_elctbl_chc epe,

888: epe.elig_per_elctbl_chc_id,
889: epe.spcl_rt_pl_id,
890: epe.spcl_rt_oipl_id,
891: pel.acty_ref_perd_cd
892: from ben_elig_per_elctbl_chc epe,
893: ben_pil_elctbl_chc_popl pel,
894: ben_prtt_enrt_rslt_f pen
895: where epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
896: and epe.per_in_ler_id = p_per_in_ler_id

Line 930: from ben_elig_per_elctbl_chc epe

926: and ecr.acty_base_rt_id = c_acty_base_rt_id;
927: --
928: cursor c_prtt_enrt (p_pgm_id number) is
929: select prtt_enrt_rslt_id
930: from ben_elig_per_elctbl_chc epe
931: where epe.per_in_ler_id = p_per_in_ler_id
932: and epe.comp_lvl_cd = 'PLANFC'
933: and epe.pgm_id = p_pgm_id
934: and epe.business_group_id = p_business_group_id;

Line 1177: from ben_elig_per_elctbl_chc epe,

1173: epe.elig_per_elctbl_chc_id,
1174: epe.spcl_rt_pl_id,
1175: epe.spcl_rt_oipl_id,
1176: pel.acty_ref_perd_cd
1177: from ben_elig_per_elctbl_chc epe,
1178: ben_pil_elctbl_chc_popl pel,
1179: ben_prtt_enrt_rslt_f pen
1180: where epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
1181: and epe.per_in_ler_id = p_per_in_ler_id

Line 1220: from ben_elig_per_elctbl_chc epe

1216: and pen.prtt_enrt_rslt_stat_cd is null;
1217: --
1218: cursor c_prtt_enrt (p_pgm_id number) is
1219: select prtt_enrt_rslt_id
1220: from ben_elig_per_elctbl_chc epe
1221: where epe.per_in_ler_id = p_per_in_ler_id
1222: and epe.comp_lvl_cd = 'PLANFC'
1223: and epe.pgm_id = p_pgm_id
1224: and epe.business_group_id = p_business_group_id;