APPS.BEN_EFC_ADJUSTMENTS1 dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 335: from ben_elig_per_elctbl_chc epe,

331: epe.elig_per_elctbl_chc_id,
332: epe.spcl_rt_pl_id,
333: epe.spcl_rt_oipl_id,
334: pel.acty_ref_perd_cd
335: from ben_elig_per_elctbl_chc epe,
336: ben_per_in_ler pil,
337: ben_pil_elctbl_chc_popl pel,
338: ben_prtt_enrt_rslt_f pen
339: where epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id

Line 2984: ben_elig_per_elctbl_chc epe

2980: ecr.ELIG_PER_ELCTBL_CHC_ID
2981: from ben_enrt_bnft enb,
2982: ben_enrt_rt ecr,
2983: ben_bnft_prvdd_ldgr_f bpl,
2984: ben_elig_per_elctbl_chc epe
2985: where ecr.DECR_BNFT_PRVDR_POOL_ID = bpl.BNFT_PRVDR_POOL_ID
2986: and ecr.acty_base_rt_id = bpl.acty_base_rt_id
2987: and ecr.enrt_bnft_id = enb.enrt_bnft_id
2988: and bpl.per_in_ler_id = epe.per_in_ler_id

Line 2997: ben_elig_per_elctbl_chc epe

2993: select ecr.prtt_rt_val_id,
2994: ecr.ELIG_PER_ELCTBL_CHC_ID
2995: from ben_enrt_rt ecr,
2996: ben_bnft_prvdd_ldgr_f bpl,
2997: ben_elig_per_elctbl_chc epe
2998: where ecr.DECR_BNFT_PRVDR_POOL_ID = bpl.BNFT_PRVDR_POOL_ID
2999: and ecr.acty_base_rt_id = bpl.acty_base_rt_id
3000: and ecr.ELIG_PER_ELCTBL_CHC_ID = epe.ELIG_PER_ELCTBL_CHC_ID
3001: and bpl.per_in_ler_id = epe.per_in_ler_id

Line 3046: ben_elig_per_elctbl_chc epe

3042: ecr.prtt_rt_val_id,
3043: ecr.val,
3044: epe.prtt_enrt_rslt_id
3045: from ben_enrt_rt ecr,
3046: ben_elig_per_elctbl_chc epe
3047: where ecr.acty_base_rt_id = c_abr_id
3048: /*
3049: and ecr.decr_bnft_prvdr_pool_id = c_bpp_id
3050: */

Line 3066: ben_elig_per_elctbl_chc epe

3062: ecr.val,
3063: epe.prtt_enrt_rslt_id
3064: from ben_enrt_rt ecr,
3065: ben_enrt_bnft enb,
3066: ben_elig_per_elctbl_chc epe
3067: where
3068: /*
3069: ecr.DECR_BNFT_PRVDR_POOL_ID = c_bpp_id
3070: and