APPS.BEN_PROVIDER_POOLS dependencies on BEN_ENRT_BNFT

Line 1064: ben_enrt_bnft enb

1060: decode(enb.enrt_bnft_id,null,
1061: nvl(ecr2.dflt_val,ecr2.val),nvl(ecr1.dflt_val,ecr1.val)) val
1062: from ben_enrt_rt ecr1,
1063: ben_enrt_rt ecr2,
1064: ben_enrt_bnft enb
1065: where ((ecr1.elig_per_elctbl_chc_id=p_epe_rec.elig_per_elctbl_chc_id
1066: and (ecr1.enrt_bnft_id = enb.enrt_bnft_id
1067: or ecr1.enrt_bnft_id is null)
1068: and ecr2.enrt_rt_id = ecr1.enrt_rt_id)

Line 1571: ben_enrt_bnft enb,

1567: from ben_elig_per_elctbl_chc epe,
1568: ben_per_in_ler pil,
1569: ben_enrt_rt ecr1,
1570: ben_enrt_rt ecr2,
1571: ben_enrt_bnft enb,
1572: ben_bnft_prvdd_ldgr_f bpl,
1573: ben_elig_per_elctbl_chc epe_flex,
1574: ben_per_in_ler pil_flex
1575: where pil.person_id=p_person_id and

Line 1728: ,ben_enrt_bnft enb

1724: select null
1725: from ben_elig_per_elctbl_chc epe
1726: ,ben_prtt_enrt_rslt_f pen
1727: ,ben_enrt_rt ecr
1728: ,ben_enrt_bnft enb
1729: where epe.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1730: and pen.person_id = p_person_id
1731: and pen.prtt_enrt_rslt_stat_cd is null
1732: and epe.business_group_id = pen.business_group_id

Line 2051: ben_enrt_bnft enb,

2047: from ben_elig_per_elctbl_chc epe,
2048: ben_per_in_ler pil,
2049: ben_enrt_rt ecr1,
2050: ben_enrt_rt ecr2,
2051: ben_enrt_bnft enb,
2052: ben_bnft_prvdd_ldgr_f bpl,
2053: ben_elig_per_elctbl_chc epe_flex,
2054: ben_per_in_ler pil_flex,
2055: ben_per_in_ler pil_flex1

Line 3428: ben_enrt_bnft enb,

3424: from
3425: ben_bnft_pool_rlovr_rqmt_f prr,
3426: ben_per_in_ler pil,
3427: ben_elig_per_elctbl_chc epe,
3428: ben_enrt_bnft enb,
3429: ben_enrt_rt ecr,
3430: ben_prtt_rt_val prv,
3431: ben_prtt_enrt_rslt_f rslt,
3432: per_all_assignments_f asg,

Line 4116: ben_enrt_bnft enb,

4112: ben_elig_per_elctbl_chc epe,
4113: ben_pil_elctbl_chc_popl pel,
4114: ben_enrt_rt ecr1,
4115: ben_enrt_rt ecr2,
4116: ben_enrt_bnft enb,
4117: ben_prtt_enrt_rslt_f pen,
4118: ben_bnft_prvdr_pool_f bpp -- join to get only current pgm_id - rgajula
4119: where pil.per_in_ler_id=p_per_in_ler_id and
4120: pil.business_group_id=p_business_group_id and

Line 5054: ben_enrt_bnft enb

5050: select nvl(ecr1.enrt_rt_id, ecr2.enrt_rt_id) enrt_rt_id
5051: from ben_enrt_rt ecr1,
5052: ben_enrt_rt ecr2,
5053: ben_elig_per_elctbl_chc epe,
5054: ben_enrt_bnft enb
5055: where epe.per_in_ler_id = p_ended_per_in_ler_id
5056: and ecr1.prtt_rt_val_id(+) = p_prtt_rt_val_id
5057: and ecr2.prtt_rt_val_id(+) = p_prtt_rt_val_id
5058: and epe.elig_per_elctbl_chc_id = ecr1.elig_per_elctbl_chc_id(+)