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 494: from ben_elig_per_elctbl_chc epe1,

490: epe.cmbn_ptip_id,
491: epe.cmbn_ptip_opt_id,
492: epe.business_group_id,
493: epe.per_in_ler_id
494: from ben_elig_per_elctbl_chc epe1,
495: ben_elig_per_elctbl_chc epe
496: where epe1.elig_per_elctbl_chc_id=p_elig_per_elctbl_chc_id and
497: epe1.business_group_id=p_business_group_id and
498: epe1.pgm_id = epe.pgm_id and -- start fix 2689926

Line 495: ben_elig_per_elctbl_chc epe

491: epe.cmbn_ptip_opt_id,
492: epe.business_group_id,
493: epe.per_in_ler_id
494: from ben_elig_per_elctbl_chc epe1,
495: ben_elig_per_elctbl_chc epe
496: where epe1.elig_per_elctbl_chc_id=p_elig_per_elctbl_chc_id and
497: epe1.business_group_id=p_business_group_id and
498: epe1.pgm_id = epe.pgm_id and -- start fix 2689926
499: /* Removed where clause as part of 2917128

Line 1294: from ben_elig_per_elctbl_chc epe

1290: --
1291: --bug#2382651
1292: cursor c_epe is
1293: select pgm_id
1294: from ben_elig_per_elctbl_chc epe
1295: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
1296: --
1297:
1298: begin

Line 1567: from ben_elig_per_elctbl_chc epe,

1563: bpl.bnft_prvdd_ldgr_id,
1564: bpl.object_version_number,
1565: decode(enb.enrt_bnft_id, null,
1566: ecr2.rt_usg_cd,ecr1.rt_usg_cd) rt_usg_cd
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,

Line 1573: ben_elig_per_elctbl_chc epe_flex,

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

Line 1682: from ben_elig_per_elctbl_chc epe1,

1678: epe.cmbn_ptip_id,
1679: epe.cmbn_ptip_opt_id,
1680: epe.business_group_id,
1681: epe.per_in_ler_id
1682: from ben_elig_per_elctbl_chc epe1,
1683: ben_elig_per_elctbl_chc epe,
1684: ben_per_in_ler pil
1685: where epe1.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id and
1686: epe1.business_group_id=p_business_group_id and

Line 1683: ben_elig_per_elctbl_chc epe,

1679: epe.cmbn_ptip_opt_id,
1680: epe.business_group_id,
1681: epe.per_in_ler_id
1682: from ben_elig_per_elctbl_chc epe1,
1683: ben_elig_per_elctbl_chc epe,
1684: ben_per_in_ler pil
1685: where epe1.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id and
1686: epe1.business_group_id=p_business_group_id and
1687: epe1.pgm_id = epe.pgm_id and

Line 1725: from ben_elig_per_elctbl_chc epe

1721: and ecr.rt_usg_cd = 'FLXCR';
1722: --
1723: cursor c_person_enrolled is
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

Line 2047: from ben_elig_per_elctbl_chc epe,

2043: bpl.bnft_prvdd_ldgr_id,
2044: bpl.object_version_number,
2045: decode(enb.enrt_bnft_id,null,
2046: ecr2.rt_usg_cd,ecr1.rt_usg_cd) rt_usg_cd
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,

Line 2053: ben_elig_per_elctbl_chc epe_flex,

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

Line 2194: from ben_elig_per_elctbl_chc epe,

2190: epe.pgm_id,
2191: epe.pl_id,
2192: per.enrt_cvg_strt_dt,
2193: per.per_in_ler_id chc_pen_id
2194: from ben_elig_per_elctbl_chc epe,
2195: ben_per_in_ler pil,
2196: ben_prtt_enrt_rslt_f per
2197: where epe.comp_lvl_cd = 'PLANFC' and
2198: epe.per_in_ler_id = p_per_in_ler_id and

Line 2948: ben_elig_per_elctbl_chc epe,

2944: CURSOR c_cash_abr_from_epe
2945: IS
2946: SELECT ecr.acty_base_rt_id
2947: FROM ben_per_in_ler pil,
2948: ben_elig_per_elctbl_chc epe,
2949: ben_enrt_rt ecr
2950: WHERE pil.person_id = p_person_id
2951: AND pil.business_group_id = p_business_group_id
2952: AND pil.per_in_ler_stat_cd NOT IN ('VOIDD', 'BCKDT')

Line 3351: ben_elig_per_elctbl_chc epe,

3347: epe.per_in_ler_id
3348: from
3349: ben_bnft_pool_rlovr_rqmt_f prr,
3350: ben_per_in_ler pil,
3351: ben_elig_per_elctbl_chc epe,
3352: ben_enrt_rt ecr,
3353: ben_prtt_rt_val prv,
3354: ben_prtt_enrt_rslt_f rslt,
3355: per_all_assignments_f asg,

Line 3427: ben_elig_per_elctbl_chc epe,

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

Line 3479: ben_elig_per_elctbl_chc epe_flex,

3475: nvl(sum(decode(prtt_ro_of_unusd_amt_flag,'N',used_val,0)),0),-- non rollovers
3476: nvl(sum(cash_recd_val),0),
3477: nvl(sum(decode(prtt_ro_of_unusd_amt_flag,'Y',used_val,0)),0) -- rollovers
3478: from ben_bnft_prvdd_ldgr_f bpl,
3479: ben_elig_per_elctbl_chc epe_flex,
3480: ben_per_in_ler pil_flex,
3481: ben_per_in_ler pil_flex1
3482: where p_effective_date between
3483: bpl.effective_start_date and bpl.effective_end_date and

Line 3510: ben_elig_per_elctbl_chc epe_flex,

3506: nvl(sum(decode(prtt_ro_of_unusd_amt_flag,'N',used_val,0)),0),-- non rollovers
3507: nvl(sum(cash_recd_val),0),
3508: nvl(sum(decode(prtt_ro_of_unusd_amt_flag,'Y',used_val,0)),0) -- rollovers
3509: from ben_bnft_prvdd_ldgr_f bpl,
3510: ben_elig_per_elctbl_chc epe_flex,
3511: ben_per_in_ler pil_flex,
3512: ben_per_in_ler pil_flex1
3513: where p_effective_date between
3514: bpl.effective_start_date and bpl.effective_end_date and

Line 3539: ben_elig_per_elctbl_chc epe_flex,

3535: bpl.used_val,
3536: bpl.object_version_number,
3537: bpl.effective_start_date
3538: from ben_bnft_prvdd_ldgr_f bpl,
3539: ben_elig_per_elctbl_chc epe_flex,
3540: ben_per_in_ler pil_flex,
3541: ben_per_in_ler pil_flex1
3542: where p_effective_date between
3543: bpl.effective_start_date and bpl.effective_end_date and

Line 4112: ben_elig_per_elctbl_chc epe,

4108: pen.prtt_enrt_rslt_id,
4109: pen.bnft_amt,
4110: pen.object_version_number
4111: from ben_per_in_ler pil,
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,

Line 4367: ben_elig_per_elctbl_chc epe_flex,

4363: nvl(sum(frftd_val),0) frftd_total,
4364: nvl(sum(cash_recd_val),0) cash_recd_total,
4365: pil_flex.ler_id
4366: from ben_bnft_prvdd_ldgr_f bpl,
4367: ben_elig_per_elctbl_chc epe_flex,
4368: ben_per_in_ler pil_flex,
4369: ben_per_in_ler pil_flex1
4370: where p_effective_date between
4371: bpl.effective_start_date and bpl.effective_end_date and

Line 4406: ben_elig_per_elctbl_chc epe,

4402: cursor c_cash_abr is
4403: select ecr.acty_base_rt_id,
4404: epe.elig_per_elctbl_chc_id
4405: from ben_per_in_ler pil,
4406: ben_elig_per_elctbl_chc epe,
4407: ben_enrt_rt ecr
4408: where pil.per_in_ler_id=p_per_in_ler_id and
4409: pil.business_group_id=p_business_group_id and
4410: pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT') and

Line 5053: ben_elig_per_elctbl_chc epe,

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

Line 5590: from ben_elig_per_elctbl_chc

5586: order by prv.rt_strt_dt desc;
5587: --
5588: cursor c_epe is
5589: select elig_per_elctbl_chc_id
5590: from ben_elig_per_elctbl_chc
5591: where prtt_enrt_rslt_id = l_prtt_enrt_rslt_id;
5592: --
5593: l_elig_per_elctbl_chc_id number;
5594: l_proc varchar2(80) := g_package||'.compute_rollovers';