APPS.BEN_DET_ENRT_RATES dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 252: ben_pil_elctbl_chc_popl pel,

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
255: and pil.per_in_ler_id=epe.per_in_ler_id
256: and pil.per_in_ler_id = p_per_in_ler_id

Line 397: ben_pil_elctbl_chc_popl pel,

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,
401: ben_prtt_enrt_rslt_f pen,

Line 958: ben_pil_elctbl_chc_popl pel,

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
962: and pen.prtt_enrt_rslt_id=v_enrt_rslt_id

Line 1243: ben_pil_elctbl_chc_popl pel,

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
1247: and pen.prtt_enrt_rslt_id=v_enrt_rslt_id