APPS.BEN_DET_ENRT_RATES dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 208: ben_pil_elctbl_chc_popl pel,

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

Line 353: ben_pil_elctbl_chc_popl pel,

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

Line 893: ben_pil_elctbl_chc_popl pel,

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

Line 1178: ben_pil_elctbl_chc_popl pel,

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