APPS.BEN_DET_ENRT_RATES dependencies on BEN_ENRT_RT

Line 246: from ben_enrt_rt ecr

242: ecr.acty_typ_cd,
243: ecr.rt_strt_dt,
244: ecr.acty_base_rt_id,
245: to_char(null) cvg_mlt_cd
246: from ben_enrt_rt ecr
247: where ecr.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
248: and ecr.SPCL_RT_ENRT_RT_ID is null
249: and ecr.entr_val_at_enrt_flag = 'N'
250: and nvl(ecr.rt_strt_dt_cd,'AED') <> 'ENTRBL' --Bug 3053267

Line 264: ben_enrt_rt ecr

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
268: and ecr.SPCL_RT_ENRT_RT_ID is null

Line 287: from ben_enrt_rt ecr

283: ecr.acty_typ_cd,
284: ecr.rt_strt_dt,
285: ecr.acty_base_rt_id,
286: to_char(null) cvg_mlt_cd
287: from ben_enrt_rt ecr
288: where ecr.spcl_rt_enrt_rt_id = v_enrt_rt_id
289: and ecr.entr_val_at_enrt_flag = 'N'
290: and ecr.asn_on_enrt_flag = 'Y'
291: and ecr.business_group_id = p_business_group_id;

Line 354: ben_enrt_rt ecr1,

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,
358: ben_bnft_prvdr_pool_f bpp -- join to get only current pgm_id - rgajula

Line 355: ben_enrt_rt ecr2,

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,
358: ben_bnft_prvdr_pool_f bpp -- join to get only current pgm_id - rgajula
359: where

Line 913: from ben_enrt_rt ecr

909: ,c_acty_base_rt_id in number
910: )
911: is
912: select DECR_BNFT_PRVDR_POOL_ID
913: from ben_enrt_rt ecr
914: where ecr.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
915: and ecr.asn_on_enrt_flag = 'Y'
916: -- and ecr.prtt_rt_val_id = c_prtt_rt_val_id
917: and ecr.acty_base_rt_id = c_acty_base_rt_id

Line 921: ben_enrt_rt ecr

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
925: and ecr.asn_on_enrt_flag = 'Y'

Line 1198: from ben_enrt_rt ecr

1194: ,c_acty_base_rt_id in number
1195: )
1196: is
1197: select DECR_BNFT_PRVDR_POOL_ID
1198: from ben_enrt_rt ecr
1199: where ecr.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
1200: and ecr.asn_on_enrt_flag = 'Y'
1201: and ecr.acty_base_rt_id = c_acty_base_rt_id
1202: UNION

Line 1205: ben_enrt_rt ecr

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
1209: and ecr.asn_on_enrt_flag = 'Y';

Line 1446: from ben_enrt_rt ecr

1442: ecr.rt_mlt_cd,
1443: ecr.acty_typ_cd,
1444: ecr.rt_strt_dt,
1445: ecr.acty_base_rt_id
1446: from ben_enrt_rt ecr
1447: where ecr.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
1448: and ecr.SPCL_RT_ENRT_RT_ID is null
1449: and ecr.entr_val_at_enrt_flag = 'N'
1450: and ecr.asn_on_enrt_flag = 'Y'

Line 1462: ben_enrt_rt ecr

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
1466: and ecr.SPCL_RT_ENRT_RT_ID is null