APPS.BEN_DET_ENRT_RATES dependencies on BEN_ENRT_RT

Line 290: from ben_enrt_rt ecr

286: ecr.acty_typ_cd,
287: ecr.rt_strt_dt,
288: ecr.acty_base_rt_id,
289: to_char(null) cvg_mlt_cd
290: from ben_enrt_rt ecr
291: where ecr.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
292: and ecr.SPCL_RT_ENRT_RT_ID is null
293: and ecr.entr_val_at_enrt_flag = 'N'
294: and nvl(ecr.rt_strt_dt_cd,'AED') <> 'ENTRBL' --Bug 3053267

Line 308: ben_enrt_rt ecr

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

Line 331: from ben_enrt_rt ecr

327: ecr.acty_typ_cd,
328: ecr.rt_strt_dt,
329: ecr.acty_base_rt_id,
330: to_char(null) cvg_mlt_cd
331: from ben_enrt_rt ecr
332: where ecr.spcl_rt_enrt_rt_id = v_enrt_rt_id
333: and ecr.entr_val_at_enrt_flag = 'N'
334: and ecr.asn_on_enrt_flag = 'Y'
335: and ecr.business_group_id = p_business_group_id;

Line 398: ben_enrt_rt ecr1,

394: pen.oipl_id
395: from ben_per_in_ler pil,
396: ben_elig_per_elctbl_chc epe,
397: ben_pil_elctbl_chc_popl pel,
398: ben_enrt_rt ecr1,
399: ben_enrt_rt ecr2,
400: ben_enrt_bnft enb,
401: ben_prtt_enrt_rslt_f pen,
402: ben_bnft_prvdr_pool_f bpp -- join to get only current pgm_id - rgajula

Line 399: ben_enrt_rt ecr2,

395: from ben_per_in_ler pil,
396: ben_elig_per_elctbl_chc epe,
397: ben_pil_elctbl_chc_popl pel,
398: ben_enrt_rt ecr1,
399: ben_enrt_rt ecr2,
400: ben_enrt_bnft enb,
401: ben_prtt_enrt_rslt_f pen,
402: ben_bnft_prvdr_pool_f bpp -- join to get only current pgm_id - rgajula
403: where

Line 978: from ben_enrt_rt ecr

974: ,c_acty_base_rt_id in number
975: )
976: is
977: select DECR_BNFT_PRVDR_POOL_ID
978: from ben_enrt_rt ecr
979: where ecr.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
980: and ecr.asn_on_enrt_flag = 'Y'
981: -- and ecr.prtt_rt_val_id = c_prtt_rt_val_id
982: and ecr.acty_base_rt_id = c_acty_base_rt_id

Line 986: ben_enrt_rt ecr

982: and ecr.acty_base_rt_id = c_acty_base_rt_id
983: UNION
984: select DECR_BNFT_PRVDR_POOL_ID
985: from ben_enrt_bnft enb,
986: ben_enrt_rt ecr
987: where enb.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
988: and enb.ENRT_BNFT_ID = ecr.ENRT_BNFT_ID
989: --and ecr.prtt_rt_val_id = c_prtt_rt_val_id
990: and ecr.asn_on_enrt_flag = 'Y'

Line 1263: from ben_enrt_rt ecr

1259: ,c_acty_base_rt_id in number
1260: )
1261: is
1262: select DECR_BNFT_PRVDR_POOL_ID
1263: from ben_enrt_rt ecr
1264: where ecr.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
1265: and ecr.asn_on_enrt_flag = 'Y'
1266: and ecr.acty_base_rt_id = c_acty_base_rt_id
1267: UNION

Line 1270: ben_enrt_rt ecr

1266: and ecr.acty_base_rt_id = c_acty_base_rt_id
1267: UNION
1268: select DECR_BNFT_PRVDR_POOL_ID
1269: from ben_enrt_bnft enb,
1270: ben_enrt_rt ecr
1271: where enb.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
1272: and enb.ENRT_BNFT_ID = ecr.ENRT_BNFT_ID
1273: and ecr.acty_base_rt_id = c_acty_base_rt_id
1274: and ecr.asn_on_enrt_flag = 'Y';

Line 1512: from ben_enrt_rt ecr

1508: ecr.acty_typ_cd,
1509: ecr.rt_strt_dt,
1510: ecr.object_version_number, -----Bug 8214477
1511: ecr.acty_base_rt_id
1512: from ben_enrt_rt ecr
1513: where ecr.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
1514: and ecr.SPCL_RT_ENRT_RT_ID is null
1515: and ecr.entr_val_at_enrt_flag = 'N'
1516: and ecr.asn_on_enrt_flag = 'Y'

Line 1529: ben_enrt_rt ecr

1525: ecr.rt_strt_dt,
1526: ecr.object_version_number, -----Bug 8214477
1527: ecr.acty_base_rt_id
1528: from ben_enrt_bnft enb,
1529: ben_enrt_rt ecr
1530: where enb.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
1531: and enb.ENRT_BNFT_ID = ecr.ENRT_BNFT_ID
1532: and enb.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1533: and ecr.SPCL_RT_ENRT_RT_ID is null