APPS.BEN_EFC_ADJUSTMENTS1 dependencies on BEN_ENRT_RT

Line 206: from ben_enrt_rt ecr

202: ecr.elig_per_elctbl_chc_id,
203: ecr.asn_on_enrt_flag,
204: ecr.entr_val_at_enrt_flag,
205: ecr.rt_strt_dt_cd
206: from ben_enrt_rt ecr
207: where ecr.prtt_rt_val_id = c_prv_id;
208: --
209: l_ecrdets c_ecrdets%rowtype;
210: --

Line 285: from ben_enrt_rt ecr

281: ecr.enrt_bnft_id,
282: ecr.elig_per_elctbl_chc_id,
283: ecr.acty_base_rt_id,
284: ecr.entr_val_at_enrt_flag
285: from ben_enrt_rt ecr
286: where ecr.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
287: and ecr.SPCL_RT_ENRT_RT_ID is null
288: /*
289: and ecr.entr_val_at_enrt_flag = 'N'

Line 307: ben_enrt_rt ecr

303: ecr.elig_per_elctbl_chc_id,
304: ecr.acty_base_rt_id,
305: ecr.entr_val_at_enrt_flag
306: from ben_enrt_bnft enb,
307: ben_enrt_rt ecr
308: where enb.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
309: and enb.ENRT_BNFT_ID = ecr.ENRT_BNFT_ID
310: and enb.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
311: and ecr.SPCL_RT_ENRT_RT_ID is null

Line 2982: ben_enrt_rt ecr,

2978: is
2979: select ecr.prtt_rt_val_id,
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

Line 2995: from ben_enrt_rt ecr,

2991: and bpl.prtt_enrt_rslt_id = c_pen_id
2992: union
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

Line 3045: from ben_enrt_rt ecr,

3041: ecr.decr_bnft_prvdr_pool_id,
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

Line 3064: from ben_enrt_rt ecr,

3060: ecr.decr_bnft_prvdr_pool_id,
3061: ecr.prtt_rt_val_id,
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: /*