APPS.BEN_DET_ENRT_RATES dependencies on BEN_ENRT_BNFT

Line 263: from ben_enrt_bnft enb,

259: ecr.acty_typ_cd,
260: ecr.rt_strt_dt,
261: ecr.acty_base_rt_id,
262: enb.cvg_mlt_cd cvg_mlt_cd
263: from ben_enrt_bnft enb,
264: ben_enrt_rt ecr
265: where enb.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
266: and enb.ENRT_BNFT_ID = ecr.ENRT_BNFT_ID
267: and enb.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id

Line 356: ben_enrt_bnft enb,

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,
358: ben_bnft_prvdr_pool_f bpp -- join to get only current pgm_id - rgajula
359: where
360: pil.per_in_ler_id=p_per_in_ler_id and

Line 920: from ben_enrt_bnft enb,

916: -- and ecr.prtt_rt_val_id = c_prtt_rt_val_id
917: and ecr.acty_base_rt_id = c_acty_base_rt_id
918: UNION
919: select DECR_BNFT_PRVDR_POOL_ID
920: from ben_enrt_bnft enb,
921: ben_enrt_rt ecr
922: where enb.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
923: and enb.ENRT_BNFT_ID = ecr.ENRT_BNFT_ID
924: --and ecr.prtt_rt_val_id = c_prtt_rt_val_id

Line 1204: from ben_enrt_bnft enb,

1200: and ecr.asn_on_enrt_flag = 'Y'
1201: and ecr.acty_base_rt_id = c_acty_base_rt_id
1202: UNION
1203: select DECR_BNFT_PRVDR_POOL_ID
1204: from ben_enrt_bnft enb,
1205: ben_enrt_rt ecr
1206: where enb.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
1207: and enb.ENRT_BNFT_ID = ecr.ENRT_BNFT_ID
1208: and ecr.acty_base_rt_id = c_acty_base_rt_id

Line 1461: from ben_enrt_bnft enb,

1457: ecr.rt_mlt_cd,
1458: ecr.acty_typ_cd,
1459: ecr.rt_strt_dt,
1460: ecr.acty_base_rt_id
1461: from ben_enrt_bnft enb,
1462: ben_enrt_rt ecr
1463: where enb.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
1464: and enb.ENRT_BNFT_ID = ecr.ENRT_BNFT_ID
1465: and enb.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id