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_ELIG_PER_ELCTBL_CHC

Line 512: from ben_elig_per_elctbl_chc epe1,

508: epe.cmbn_ptip_id,
509: epe.cmbn_ptip_opt_id,
510: epe.business_group_id,
511: epe.per_in_ler_id
512: from ben_elig_per_elctbl_chc epe1,
513: ben_elig_per_elctbl_chc epe
514: where epe1.elig_per_elctbl_chc_id=p_elig_per_elctbl_chc_id and
515: epe1.business_group_id=p_business_group_id and
516: epe1.pgm_id = epe.pgm_id and -- start fix 2689926

Line 513: ben_elig_per_elctbl_chc epe

509: epe.cmbn_ptip_opt_id,
510: epe.business_group_id,
511: epe.per_in_ler_id
512: from ben_elig_per_elctbl_chc epe1,
513: ben_elig_per_elctbl_chc epe
514: where epe1.elig_per_elctbl_chc_id=p_elig_per_elctbl_chc_id and
515: epe1.business_group_id=p_business_group_id and
516: epe1.pgm_id = epe.pgm_id and -- start fix 2689926
517: /* Removed where clause as part of 2917128

Line 1313: from ben_elig_per_elctbl_chc epe

1309: --
1310: --bug#2382651
1311: cursor c_epe is
1312: select pgm_id
1313: from ben_elig_per_elctbl_chc epe
1314: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
1315: --
1316:
1317: begin

Line 1586: from ben_elig_per_elctbl_chc epe,

1582: bpl.bnft_prvdd_ldgr_id,
1583: bpl.object_version_number,
1584: decode(enb.enrt_bnft_id, null,
1585: ecr2.rt_usg_cd,ecr1.rt_usg_cd) rt_usg_cd
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,

Line 1592: ben_elig_per_elctbl_chc epe_flex,

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
1595: pil.business_group_id=p_business_group_id and
1596: pil.per_in_ler_stat_cd='STRTD' and

Line 1663: FROM ben_elig_per_elctbl_chc epe

1659: ---------------Bug 8504085
1660: ----------Get the flex credit epe ID against the comp object
1661: cursor c_get_credit_ledger_epe(p_pil_id number,p_oipl_id number) is
1662: SELECT *
1663: FROM ben_elig_per_elctbl_chc epe
1664: WHERE epe.per_in_ler_id = p_pil_id
1665: AND epe.business_group_id = p_business_group_id
1666: AND epe.bnft_prvdr_pool_id is not null
1667: AND epe.oipl_id = p_oipl_id

Line 1742: from ben_elig_per_elctbl_chc epe1,

1738: epe.cmbn_ptip_id,
1739: epe.cmbn_ptip_opt_id,
1740: epe.business_group_id,
1741: epe.per_in_ler_id
1742: from ben_elig_per_elctbl_chc epe1,
1743: ben_elig_per_elctbl_chc epe,
1744: ben_per_in_ler pil
1745: where epe1.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id and
1746: epe1.business_group_id=p_business_group_id and

Line 1743: ben_elig_per_elctbl_chc epe,

1739: epe.cmbn_ptip_opt_id,
1740: epe.business_group_id,
1741: epe.per_in_ler_id
1742: from ben_elig_per_elctbl_chc epe1,
1743: ben_elig_per_elctbl_chc epe,
1744: ben_per_in_ler pil
1745: where epe1.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id and
1746: epe1.business_group_id=p_business_group_id and
1747: epe1.pgm_id = epe.pgm_id and

Line 1785: from ben_elig_per_elctbl_chc epe

1781: and ecr.rt_usg_cd = 'FLXCR';
1782: --
1783: cursor c_person_enrolled is
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

Line 2178: from ben_elig_per_elctbl_chc epe,

2174: bpl.bnft_prvdd_ldgr_id,
2175: bpl.object_version_number,
2176: decode(enb.enrt_bnft_id,null,
2177: ecr2.rt_usg_cd,ecr1.rt_usg_cd) rt_usg_cd
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,

Line 2184: ben_elig_per_elctbl_chc epe_flex,

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
2187: where pil.per_in_ler_id = p_per_in_ler_id and
2188: pil.business_group_id=p_business_group_id and

Line 2325: from ben_elig_per_elctbl_chc epe,

2321: epe.pgm_id,
2322: epe.pl_id,
2323: per.enrt_cvg_strt_dt,
2324: per.per_in_ler_id chc_pen_id
2325: from ben_elig_per_elctbl_chc epe,
2326: ben_per_in_ler pil,
2327: ben_prtt_enrt_rslt_f per
2328: where epe.comp_lvl_cd = 'PLANFC' and
2329: epe.per_in_ler_id = p_per_in_ler_id and

Line 3127: ben_elig_per_elctbl_chc epe,

3123: CURSOR c_cash_abr_from_epe
3124: IS
3125: SELECT ecr.acty_base_rt_id
3126: FROM ben_per_in_ler pil,
3127: ben_elig_per_elctbl_chc epe,
3128: ben_enrt_rt ecr
3129: WHERE pil.person_id = p_person_id
3130: AND pil.business_group_id = p_business_group_id
3131: AND pil.per_in_ler_stat_cd NOT IN ('VOIDD', 'BCKDT')

Line 3530: ben_elig_per_elctbl_chc epe,

3526: epe.per_in_ler_id
3527: from
3528: ben_bnft_pool_rlovr_rqmt_f prr,
3529: ben_per_in_ler pil,
3530: ben_elig_per_elctbl_chc epe,
3531: ben_enrt_rt ecr,
3532: ben_prtt_rt_val prv,
3533: ben_prtt_enrt_rslt_f rslt,
3534: per_all_assignments_f asg,

Line 3606: ben_elig_per_elctbl_chc epe,

3602: epe.per_in_ler_id
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,

Line 3658: ben_elig_per_elctbl_chc epe_flex,

3654: nvl(sum(decode(prtt_ro_of_unusd_amt_flag,'N',used_val,0)),0),-- non rollovers
3655: nvl(sum(cash_recd_val),0),
3656: nvl(sum(decode(prtt_ro_of_unusd_amt_flag,'Y',used_val,0)),0) -- rollovers
3657: from ben_bnft_prvdd_ldgr_f bpl,
3658: ben_elig_per_elctbl_chc epe_flex,
3659: ben_per_in_ler pil_flex,
3660: ben_per_in_ler pil_flex1
3661: where p_effective_date between
3662: bpl.effective_start_date and bpl.effective_end_date and

Line 3689: ben_elig_per_elctbl_chc epe_flex,

3685: nvl(sum(decode(prtt_ro_of_unusd_amt_flag,'N',used_val,0)),0),-- non rollovers
3686: nvl(sum(cash_recd_val),0),
3687: nvl(sum(decode(prtt_ro_of_unusd_amt_flag,'Y',used_val,0)),0) -- rollovers
3688: from ben_bnft_prvdd_ldgr_f bpl,
3689: ben_elig_per_elctbl_chc epe_flex,
3690: ben_per_in_ler pil_flex,
3691: ben_per_in_ler pil_flex1
3692: where p_effective_date between
3693: bpl.effective_start_date and bpl.effective_end_date and

Line 3718: ben_elig_per_elctbl_chc epe_flex,

3714: bpl.used_val,
3715: bpl.object_version_number,
3716: bpl.effective_start_date
3717: from ben_bnft_prvdd_ldgr_f bpl,
3718: ben_elig_per_elctbl_chc epe_flex,
3719: ben_per_in_ler pil_flex,
3720: ben_per_in_ler pil_flex1
3721: where p_effective_date between
3722: bpl.effective_start_date and bpl.effective_end_date and

Line 4291: ben_elig_per_elctbl_chc epe,

4287: pen.prtt_enrt_rslt_id,
4288: pen.bnft_amt,
4289: pen.object_version_number
4290: from ben_per_in_ler pil,
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,

Line 4546: ben_elig_per_elctbl_chc epe_flex,

4542: nvl(sum(frftd_val),0) frftd_total,
4543: nvl(sum(cash_recd_val),0) cash_recd_total,
4544: pil_flex.ler_id
4545: from ben_bnft_prvdd_ldgr_f bpl,
4546: ben_elig_per_elctbl_chc epe_flex,
4547: ben_per_in_ler pil_flex,
4548: ben_per_in_ler pil_flex1
4549: where p_effective_date between
4550: bpl.effective_start_date and bpl.effective_end_date and

Line 4585: ben_elig_per_elctbl_chc epe,

4581: cursor c_cash_abr is
4582: select ecr.acty_base_rt_id,
4583: epe.elig_per_elctbl_chc_id
4584: from ben_per_in_ler pil,
4585: ben_elig_per_elctbl_chc epe,
4586: ben_enrt_rt ecr
4587: where pil.per_in_ler_id=p_per_in_ler_id and
4588: pil.business_group_id=p_business_group_id and
4589: pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT') and

Line 5230: ben_elig_per_elctbl_chc epe,

5226: cursor c_ecr is
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

Line 5767: from ben_elig_per_elctbl_chc

5763: order by prv.rt_strt_dt desc;
5764: --
5765: cursor c_epe is
5766: select elig_per_elctbl_chc_id
5767: from ben_elig_per_elctbl_chc
5768: where prtt_enrt_rslt_id = l_prtt_enrt_rslt_id;
5769: --
5770: l_elig_per_elctbl_chc_id number;
5771: l_proc varchar2(80) := g_package||'.compute_rollovers';