eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PROVIDER_POOLS dependencies on BEN_ENRT_BNFT

Line 1082: ben_enrt_bnft enb

1078: decode(enb.enrt_bnft_id,null,
1079: nvl(ecr2.dflt_val,ecr2.val),nvl(ecr1.dflt_val,ecr1.val)) val
1080: from ben_enrt_rt ecr1,
1081: ben_enrt_rt ecr2,
1082: ben_enrt_bnft enb
1083: where ((ecr1.elig_per_elctbl_chc_id=p_epe_rec.elig_per_elctbl_chc_id
1084: and (ecr1.enrt_bnft_id = enb.enrt_bnft_id
1085: or ecr1.enrt_bnft_id is null)
1086: and ecr2.enrt_rt_id = ecr1.enrt_rt_id)

Line 1590: ben_enrt_bnft enb,

1586: from ben_elig_per_elctbl_chc epe,
1587: ben_per_in_ler pil,
1588: ben_enrt_rt ecr1,
1589: ben_enrt_rt ecr2,
1590: ben_enrt_bnft enb,
1591: ben_bnft_prvdd_ldgr_f bpl,
1592: ben_elig_per_elctbl_chc epe_flex,
1593: ben_per_in_ler pil_flex
1594: where pil.person_id=p_person_id and

Line 1788: ,ben_enrt_bnft enb

1784: select null
1785: from ben_elig_per_elctbl_chc epe
1786: ,ben_prtt_enrt_rslt_f pen
1787: ,ben_enrt_rt ecr
1788: ,ben_enrt_bnft enb
1789: where epe.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1790: and pen.person_id = p_person_id
1791: and pen.prtt_enrt_rslt_stat_cd is null
1792: and epe.business_group_id = pen.business_group_id

Line 2182: ben_enrt_bnft enb,

2178: from ben_elig_per_elctbl_chc epe,
2179: ben_per_in_ler pil,
2180: ben_enrt_rt ecr1,
2181: ben_enrt_rt ecr2,
2182: ben_enrt_bnft enb,
2183: ben_bnft_prvdd_ldgr_f bpl,
2184: ben_elig_per_elctbl_chc epe_flex,
2185: ben_per_in_ler pil_flex,
2186: ben_per_in_ler pil_flex1

Line 3607: ben_enrt_bnft enb,

3603: from
3604: ben_bnft_pool_rlovr_rqmt_f prr,
3605: ben_per_in_ler pil,
3606: ben_elig_per_elctbl_chc epe,
3607: ben_enrt_bnft enb,
3608: ben_enrt_rt ecr,
3609: ben_prtt_rt_val prv,
3610: ben_prtt_enrt_rslt_f rslt,
3611: per_all_assignments_f asg,

Line 4295: ben_enrt_bnft enb,

4291: ben_elig_per_elctbl_chc epe,
4292: ben_pil_elctbl_chc_popl pel,
4293: ben_enrt_rt ecr1,
4294: ben_enrt_rt ecr2,
4295: ben_enrt_bnft enb,
4296: ben_prtt_enrt_rslt_f pen,
4297: ben_bnft_prvdr_pool_f bpp -- join to get only current pgm_id - rgajula
4298: where pil.per_in_ler_id=p_per_in_ler_id and
4299: pil.business_group_id=p_business_group_id and

Line 5231: ben_enrt_bnft enb

5227: select nvl(ecr1.enrt_rt_id, ecr2.enrt_rt_id) enrt_rt_id
5228: from ben_enrt_rt ecr1,
5229: ben_enrt_rt ecr2,
5230: ben_elig_per_elctbl_chc epe,
5231: ben_enrt_bnft enb
5232: where epe.per_in_ler_id = p_ended_per_in_ler_id
5233: and ecr1.prtt_rt_val_id(+) = p_prtt_rt_val_id
5234: and ecr2.prtt_rt_val_id(+) = p_prtt_rt_val_id
5235: and epe.elig_per_elctbl_chc_id = ecr1.elig_per_elctbl_chc_id(+)