APPS.BEN_DET_ENRT_RATES dependencies on BEN_ENRT_BNFT

Line 307: from ben_enrt_bnft enb,

303: ecr.acty_typ_cd,
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

Line 400: ben_enrt_bnft enb,

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
404: pil.per_in_ler_id=p_per_in_ler_id and

Line 985: from ben_enrt_bnft enb,

981: -- and ecr.prtt_rt_val_id = c_prtt_rt_val_id
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

Line 1269: from ben_enrt_bnft enb,

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

Line 1528: from ben_enrt_bnft enb,

1524: ecr.acty_typ_cd,
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