APPS.BEN_EFC_ADJUSTMENTS1 dependencies on BEN_ENRT_BNFT

Line 162: from ben_enrt_bnft enb

158: (c_enb_id in number
159: )
160: is
161: select enb.prtt_enrt_rslt_id
162: from ben_enrt_bnft enb
163: where enb.enrt_bnft_id = c_enb_id;
164: --
165: l_enbdets c_enbdets%rowtype;
166: --

Line 306: from ben_enrt_bnft enb,

302: ecr.enrt_bnft_id,
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

Line 2981: from ben_enrt_bnft enb,

2977: )
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

Line 3065: ben_enrt_bnft enb,

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: /*
3069: ecr.DECR_BNFT_PRVDR_POOL_ID = c_bpp_id