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_PRTT_ENRT_RSLT_F

Line 628: from ben_prtt_enrt_rslt_f per

624: l_proc varchar2(72) := g_package||'.person_enrolled_in_choice';
625:
626: cursor c_pgm_enrolment is
627: select 'x'
628: from ben_prtt_enrt_rslt_f per
629: where per.person_id=p_person_id and
630: per.business_group_id=p_epe_rec.business_group_id and
631: p_effective_date between
632: per.effective_start_date and per.effective_end_date and

Line 646: from ben_prtt_enrt_rslt_f per,

642: per.sspndd_flag='N';
643:
644: cursor c_ptip_enrolment is
645: select 'x'
646: from ben_prtt_enrt_rslt_f per,
647: ben_pl_f pl,
648: ben_ptip_f pt
649: where per.person_id=p_person_id and
650: per.business_group_id=p_epe_rec.business_group_id and

Line 668: from ben_prtt_enrt_rslt_f per,

664: p_epe_rec.ptip_id=pt.ptip_id;
665:
666: cursor c_cmbn_ptip_enrolment is
667: select 'x'
668: from ben_prtt_enrt_rslt_f per,
669: ben_pl_f pl,
670: ben_ptip_f pt
671: where per.person_id=p_person_id and
672: per.business_group_id=p_epe_rec.business_group_id and

Line 690: from ben_prtt_enrt_rslt_f per,

686: p_epe_rec.cmbn_ptip_id=pt.cmbn_ptip_id;
687:
688: cursor c_cmbn_plip_enrolment is
689: select 'x'
690: from ben_prtt_enrt_rslt_f per,
691: ben_pl_f pl,
692: ben_plip_f cpp
693: where per.person_id=p_person_id and
694: per.business_group_id=p_epe_rec.business_group_id and

Line 712: from ben_prtt_enrt_rslt_f per,

708: p_epe_rec.cmbn_plip_id=cpp.cmbn_plip_id;
709: /* bug 1285336
710: cursor c_cmbn_ptip_opt_enrolment is
711: select 'x'
712: from ben_prtt_enrt_rslt_f per,
713: ben_pl_f pl,
714: ben_ptip_f pt,
715: ben_oipl_f oipl,
716: ben_opt_f opt

Line 744: from ben_prtt_enrt_rslt_f per,

740: ;
741: */
742: cursor c_cmbn_ptip_opt_enrolment is
743: select 'x'
744: from ben_prtt_enrt_rslt_f per,
745: ben_pl_f pl,
746: ben_optip_f otp,
747: ben_oipl_f oipl
748: where per.person_id=p_person_id and

Line 775: from ben_prtt_enrt_rslt_f per

771: ;
772:
773: cursor c_plan_enrolment is
774: select 'x'
775: from ben_prtt_enrt_rslt_f per
776: where per.person_id=p_person_id and
777: per.business_group_id=p_epe_rec.business_group_id and
778: per.prtt_enrt_rslt_id<>p_old_result_id and
779: per.sspndd_flag='N' and

Line 791: from ben_prtt_enrt_rslt_f per

787: p_epe_rec.pgm_id = per.pgm_id; -- Added : 4964766
788:
789: cursor c_oipl_enrolment is
790: select 'x'
791: from ben_prtt_enrt_rslt_f per
792: where per.person_id=p_person_id and
793: per.business_group_id=p_epe_rec.business_group_id and
794: per.prtt_enrt_rslt_id<>p_old_result_id and
795: per.sspndd_flag='N' and

Line 807: from ben_prtt_enrt_rslt_f per,ben_oiplip_f oiplip,ben_plip_f cpp

803: p_epe_rec.pgm_id = per.pgm_id; -- Added : 4964766
804:
805: cursor c_oiplip_enrolment is
806: select 'x'
807: from ben_prtt_enrt_rslt_f per,ben_oiplip_f oiplip,ben_plip_f cpp
808: where per.person_id=p_person_id and
809: per.business_group_id=p_epe_rec.business_group_id and
810: per.prtt_enrt_rslt_id<>p_old_result_id and
811: per.sspndd_flag='N' and

Line 1600: from ben_prtt_enrt_rslt_f pen

1596: ;
1597:
1598: cursor c_rslt_exist is
1599: select pen.prtt_enrt_rslt_id
1600: from ben_prtt_enrt_rslt_f pen
1601: where pen.prtt_enrt_rslt_id <> p_prtt_enrt_rslt_id
1602: and pen.comp_lvl_cd <> 'PLANFC'
1603: and pen.person_id = p_person_id
1604: and p_effective_date between

Line 1630: from ben_prtt_enrt_rslt_f

1626: select enrt_cvg_strt_dt,
1627: enrt_cvg_thru_dt,
1628: prtt_enrt_rslt_stat_cd,
1629: sspndd_flag
1630: from ben_prtt_enrt_rslt_f
1631: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1632: and p_effective_date between effective_start_date
1633: and effective_end_date;
1634: --

Line 1642: from ben_prtt_enrt_rslt_f

1638: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id;
1639: --
1640: cursor c_flx_credit_plan is
1641: select prtt_enrt_rslt_id
1642: from ben_prtt_enrt_rslt_f
1643: where person_id = p_person_id
1644: and comp_lvl_cd = 'PLANFC'
1645: and prtt_enrt_rslt_stat_cd is null
1646: -- added effective_end_date line Bug# 2254326

Line 1726: ,ben_prtt_enrt_rslt_f pen

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
1730: and pen.person_id = p_person_id

Line 2196: ben_prtt_enrt_rslt_f per

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
2199: per.prtt_enrt_rslt_stat_cd is null and
2200: epe.business_group_id=p_business_group_id and

Line 2592: from ben_prtt_enrt_rslt_f res

2588: l_person_id number;
2589:
2590: cursor c_result is
2591: select person_id
2592: from ben_prtt_enrt_rslt_f res
2593: where res.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id and
2594: --res.prtt_enrt_rslt_stat_cd is null and
2595: p_effective_date between
2596: res.effective_start_date and res.effective_end_date and

Line 3354: ben_prtt_enrt_rslt_f rslt,

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,
3356: hr_locations_all loc,
3357: ben_oipl_f oipl
3358: where

Line 3431: ben_prtt_enrt_rslt_f rslt,

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,
3433: hr_locations_all loc,
3434: ben_oipl_f oipl
3435: where

Line 4117: ben_prtt_enrt_rslt_f pen,

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
4121: pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT') and

Line 4441: ben_prtt_enrt_rslt_f res

4437: abr.element_type_id
4438: from ben_prtt_rt_val prv,
4439: ben_enrt_rt ecr,
4440: ben_acty_base_rt_f abr,
4441: ben_prtt_enrt_rslt_f res
4442: where prv.prtt_rt_val_id=p_prtt_rt_val_id and
4443: prv.business_group_id=p_business_group_id and
4444: ecr.prtt_rt_val_id=prv.prtt_rt_val_id and
4445: ecr.business_group_id=p_business_group_id and

Line 4503: ben_prtt_enrt_rslt_f pen

4499: -- cursor to fin is that an defult enrollemt
4500: -- chne any of the current result has default enrollment
4501: cursor c_get_mthd is
4502: select 'x' from
4503: ben_prtt_enrt_rslt_f pen
4504: where pen.per_in_ler_id = p_per_in_ler_id
4505: and pen.prtt_enrt_rslt_stat_cd is null
4506: and pen.enrt_mthd_cd = 'D'
4507: and p_effective_date between

Line 5029: from ben_prtt_enrt_rslt_f pen

5025: pen.pl_id,
5026: pen.oipl_id,
5027: pen.person_id,
5028: pen.ler_id
5029: from ben_prtt_enrt_rslt_f pen
5030: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5031: and pen.business_group_id = p_business_group_id
5032: and pen.prtt_enrt_rslt_stat_cd is null
5033: and p_effective_date between

Line 5299: from ben_prtt_enrt_rslt_f pen,

5295: pen.effective_start_date,
5296: abr.entr_val_at_enrt_flag,
5297: prv.prtt_rt_val_id,
5298: prv.rt_val
5299: from ben_prtt_enrt_rslt_f pen,
5300: ben_prtt_rt_val prv,
5301: ben_acty_base_rt_f abr
5302: where prv.acty_base_rt_id = v_acty_base_rt_id
5303: and prv.business_group_id = p_business_group_id

Line 5492: ben_prtt_enrt_rslt_f rslt,

5488: rslt.pl_typ_id
5489: from
5490: ben_bnft_pool_rlovr_rqmt_f prr,
5491: ben_prtt_rt_val prv,
5492: ben_prtt_enrt_rslt_f rslt,
5493: per_all_assignments_f asg,
5494: hr_locations_all loc,
5495: ben_oipl_f oipl
5496: where

Line 5580: from ben_prtt_rt_val prv -- ,ben_prtt_enrt_rslt_f pen

5576: cursor c_prv (c_per_in_ler_id number) is -- 5257226: added parameter
5577: select prv.prtt_rt_val_id,
5578: prv.rt_val,
5579: prv.rt_strt_dt
5580: from ben_prtt_rt_val prv -- ,ben_prtt_enrt_rslt_f pen
5581: where prv.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
5582: and prv.acty_base_rt_id = l_acty_base_rt_id
5583: and prv.prtt_rt_val_stat_cd is null
5584: and prv.business_group_id = p_business_group_id

Line 6207: from ben_prtt_enrt_rslt_f pen

6203: l_prv_child_rec c_prv_child%rowtype;
6204: --
6205: cursor c_pen is
6206: select pen.*
6207: from ben_prtt_enrt_rslt_f pen
6208: where pen.prtt_enrt_rslt_id = p_flex_rslt_id
6209: and pen.business_group_id = p_business_group_id
6210: and p_effective_date
6211: between pen.effective_start_date and

Line 6623: from ben_prtt_enrt_rslt_f enrt_pen,

6619: bpl.object_version_number,
6620: bpl.effective_start_date,
6621: bpl.bnft_prvdr_pool_id,
6622: bpl.prtt_enrt_rslt_id
6623: from ben_prtt_enrt_rslt_f enrt_pen,
6624: ben_prtt_rt_val enrt_prv,
6625: ben_bnft_prvdd_ldgr_f bpl,
6626: ben_per_in_ler pil,
6627: ben_prtt_enrt_rslt_f flex_pen

Line 6627: ben_prtt_enrt_rslt_f flex_pen

6623: from ben_prtt_enrt_rslt_f enrt_pen,
6624: ben_prtt_rt_val enrt_prv,
6625: ben_bnft_prvdd_ldgr_f bpl,
6626: ben_per_in_ler pil,
6627: ben_prtt_enrt_rslt_f flex_pen
6628: where enrt_pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6629: and enrt_pen.prtt_enrt_rslt_stat_cd is null
6630: and enrt_pen.enrt_cvg_thru_dt = hr_api.g_eot
6631: and p_effective_date between

Line 6667: from ben_prtt_enrt_rslt_f flex_pen,

6663: bpp.bnft_prvdr_pool_id,
6664: bpl.prvdd_val,
6665: bpl.prtt_enrt_rslt_id,
6666: bpp.uses_net_crs_mthd_flag
6667: from ben_prtt_enrt_rslt_f flex_pen,
6668: ben_bnft_prvdd_ldgr_f bpl,
6669: ben_per_in_ler pil,
6670: ben_bnft_prvdr_pool_f bpp
6671: where flex_pen.person_id = p_person_id

Line 6742: ,ben_prtt_enrt_rslt_f pen

6738: --
6739: cursor c_abr(p_acty_typ_cd in varchar2) is
6740: select abr.acty_base_rt_id
6741: from ben_acty_base_rt_f abr
6742: ,ben_prtt_enrt_rslt_f pen
6743: where abr.pl_id = pen.pl_id
6744: and pen.prtt_enrt_rslt_id = l_flex_rslt_id
6745: and abr.business_group_id = p_business_group_id
6746: and pen.business_group_id = abr.business_group_id