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 646: from ben_prtt_enrt_rslt_f per

642: l_proc varchar2(72) := g_package||'.person_enrolled_in_choice';
643:
644: cursor c_pgm_enrolment is
645: select 'x'
646: from ben_prtt_enrt_rslt_f per
647: where per.person_id=p_person_id and
648: per.business_group_id=p_epe_rec.business_group_id and
649: p_effective_date between
650: per.effective_start_date and per.effective_end_date and

Line 664: from ben_prtt_enrt_rslt_f per,

660: per.sspndd_flag='N';
661:
662: cursor c_ptip_enrolment is
663: select 'x'
664: from ben_prtt_enrt_rslt_f per,
665: ben_pl_f pl,
666: ben_ptip_f pt
667: where per.person_id=p_person_id and
668: per.business_group_id=p_epe_rec.business_group_id and

Line 686: from ben_prtt_enrt_rslt_f per,

682: p_epe_rec.ptip_id=pt.ptip_id;
683:
684: cursor c_cmbn_ptip_enrolment is
685: select 'x'
686: from ben_prtt_enrt_rslt_f per,
687: ben_pl_f pl,
688: ben_ptip_f pt
689: where per.person_id=p_person_id and
690: per.business_group_id=p_epe_rec.business_group_id and

Line 708: from ben_prtt_enrt_rslt_f per,

704: p_epe_rec.cmbn_ptip_id=pt.cmbn_ptip_id;
705:
706: cursor c_cmbn_plip_enrolment is
707: select 'x'
708: from ben_prtt_enrt_rslt_f per,
709: ben_pl_f pl,
710: ben_plip_f cpp
711: where per.person_id=p_person_id and
712: per.business_group_id=p_epe_rec.business_group_id and

Line 730: from ben_prtt_enrt_rslt_f per,

726: p_epe_rec.cmbn_plip_id=cpp.cmbn_plip_id;
727: /* bug 1285336
728: cursor c_cmbn_ptip_opt_enrolment is
729: select 'x'
730: from ben_prtt_enrt_rslt_f per,
731: ben_pl_f pl,
732: ben_ptip_f pt,
733: ben_oipl_f oipl,
734: ben_opt_f opt

Line 762: from ben_prtt_enrt_rslt_f per,

758: ;
759: */
760: cursor c_cmbn_ptip_opt_enrolment is
761: select 'x'
762: from ben_prtt_enrt_rslt_f per,
763: ben_pl_f pl,
764: ben_optip_f otp,
765: ben_oipl_f oipl
766: where per.person_id=p_person_id and

Line 793: from ben_prtt_enrt_rslt_f per

789: ;
790:
791: cursor c_plan_enrolment is
792: select 'x'
793: from ben_prtt_enrt_rslt_f per
794: where per.person_id=p_person_id and
795: per.business_group_id=p_epe_rec.business_group_id and
796: per.prtt_enrt_rslt_id<>p_old_result_id and
797: per.sspndd_flag='N' and

Line 809: from ben_prtt_enrt_rslt_f per

805: p_epe_rec.pgm_id = per.pgm_id; -- Added : 4964766
806:
807: cursor c_oipl_enrolment is
808: select 'x'
809: from ben_prtt_enrt_rslt_f per
810: where per.person_id=p_person_id and
811: per.business_group_id=p_epe_rec.business_group_id and
812: per.prtt_enrt_rslt_id<>p_old_result_id and
813: per.sspndd_flag='N' and

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

821: p_epe_rec.pgm_id = per.pgm_id; -- Added : 4964766
822:
823: cursor c_oiplip_enrolment is
824: select 'x'
825: from ben_prtt_enrt_rslt_f per,ben_oiplip_f oiplip,ben_plip_f cpp
826: where per.person_id=p_person_id and
827: per.business_group_id=p_epe_rec.business_group_id and
828: per.prtt_enrt_rslt_id<>p_old_result_id and
829: per.sspndd_flag='N' and

Line 1619: from ben_prtt_enrt_rslt_f pen

1615: ;
1616:
1617: cursor c_rslt_exist is
1618: select pen.prtt_enrt_rslt_id
1619: from ben_prtt_enrt_rslt_f pen
1620: where pen.prtt_enrt_rslt_id <> p_prtt_enrt_rslt_id
1621: and pen.comp_lvl_cd <> 'PLANFC'
1622: and pen.person_id = p_person_id
1623: and p_effective_date between

Line 1649: from ben_prtt_enrt_rslt_f

1645: select enrt_cvg_strt_dt,
1646: enrt_cvg_thru_dt,
1647: prtt_enrt_rslt_stat_cd,
1648: sspndd_flag
1649: from ben_prtt_enrt_rslt_f
1650: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1651: and p_effective_date between effective_start_date
1652: and effective_end_date;
1653: --

Line 1682: from ben_prtt_enrt_rslt_f

1678: l_acty_base_rt1 c_acty_base_rt1%rowtype;
1679: ---------------Bug 8504085
1680: cursor c_flx_credit_plan is
1681: select prtt_enrt_rslt_id
1682: from ben_prtt_enrt_rslt_f
1683: where person_id = p_person_id
1684: and comp_lvl_cd = 'PLANFC'
1685: and prtt_enrt_rslt_stat_cd is null
1686: -- added effective_end_date line Bug# 2254326

Line 1710: from ben_prtt_enrt_rslt_f pen1,

1706:
1707: /* Bug 13010726 */
1708: cursor c_flx_credit_plan_deenrt is
1709: select pen1.prtt_enrt_rslt_id,pen1.per_in_ler_id
1710: from ben_prtt_enrt_rslt_f pen1,
1711: ben_prtt_enrt_rslt_f pen2
1712: where pen1.person_id = p_person_id
1713: and pen1.comp_lvl_cd = 'PLANFC'
1714: and pen1.prtt_enrt_rslt_stat_cd is null

Line 1711: ben_prtt_enrt_rslt_f pen2

1707: /* Bug 13010726 */
1708: cursor c_flx_credit_plan_deenrt is
1709: select pen1.prtt_enrt_rslt_id,pen1.per_in_ler_id
1710: from ben_prtt_enrt_rslt_f pen1,
1711: ben_prtt_enrt_rslt_f pen2
1712: where pen1.person_id = p_person_id
1713: and pen1.comp_lvl_cd = 'PLANFC'
1714: and pen1.prtt_enrt_rslt_stat_cd is null
1715: and pen1.effective_end_date = hr_api.g_eot

Line 1786: ,ben_prtt_enrt_rslt_f pen

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

Line 2327: ben_prtt_enrt_rslt_f per

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

Line 2723: from ben_prtt_enrt_rslt_f res

2719: l_person_id number;
2720:
2721: cursor c_result is
2722: select person_id
2723: from ben_prtt_enrt_rslt_f res
2724: where res.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id and
2725: --res.prtt_enrt_rslt_stat_cd is null and
2726: p_effective_date between
2727: res.effective_start_date and res.effective_end_date and

Line 3533: ben_prtt_enrt_rslt_f rslt,

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,
3535: hr_locations_all loc,
3536: ben_oipl_f oipl
3537: where

Line 3610: ben_prtt_enrt_rslt_f rslt,

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,
3612: hr_locations_all loc,
3613: ben_oipl_f oipl
3614: where

Line 4296: ben_prtt_enrt_rslt_f pen,

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

Line 4620: ben_prtt_enrt_rslt_f res

4616: abr.element_type_id
4617: from ben_prtt_rt_val prv,
4618: ben_enrt_rt ecr,
4619: ben_acty_base_rt_f abr,
4620: ben_prtt_enrt_rslt_f res
4621: where prv.prtt_rt_val_id=p_prtt_rt_val_id and
4622: prv.business_group_id=p_business_group_id and
4623: ecr.prtt_rt_val_id=prv.prtt_rt_val_id and
4624: ecr.business_group_id=p_business_group_id and

Line 4682: ben_prtt_enrt_rslt_f pen

4678: -- cursor to fin is that an defult enrollemt
4679: -- chne any of the current result has default enrollment
4680: cursor c_get_mthd is
4681: select 'x' from
4682: ben_prtt_enrt_rslt_f pen
4683: where pen.per_in_ler_id = p_per_in_ler_id
4684: and pen.prtt_enrt_rslt_stat_cd is null
4685: and pen.enrt_mthd_cd = 'D'
4686: and p_effective_date between

Line 5206: from ben_prtt_enrt_rslt_f pen

5202: pen.pl_id,
5203: pen.oipl_id,
5204: pen.person_id,
5205: pen.ler_id
5206: from ben_prtt_enrt_rslt_f pen
5207: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5208: and pen.business_group_id = p_business_group_id
5209: and pen.prtt_enrt_rslt_stat_cd is null
5210: and p_effective_date between

Line 5476: from ben_prtt_enrt_rslt_f pen,

5472: pen.effective_start_date,
5473: abr.entr_val_at_enrt_flag,
5474: prv.prtt_rt_val_id,
5475: prv.rt_val
5476: from ben_prtt_enrt_rslt_f pen,
5477: ben_prtt_rt_val prv,
5478: ben_acty_base_rt_f abr
5479: where prv.acty_base_rt_id = v_acty_base_rt_id
5480: and prv.business_group_id = p_business_group_id

Line 5669: ben_prtt_enrt_rslt_f rslt,

5665: rslt.pl_typ_id
5666: from
5667: ben_bnft_pool_rlovr_rqmt_f prr,
5668: ben_prtt_rt_val prv,
5669: ben_prtt_enrt_rslt_f rslt,
5670: per_all_assignments_f asg,
5671: hr_locations_all loc,
5672: ben_oipl_f oipl
5673: where

Line 5757: from ben_prtt_rt_val prv -- ,ben_prtt_enrt_rslt_f pen

5753: cursor c_prv (c_per_in_ler_id number) is -- 5257226: added parameter
5754: select prv.prtt_rt_val_id,
5755: prv.rt_val,
5756: prv.rt_strt_dt
5757: from ben_prtt_rt_val prv -- ,ben_prtt_enrt_rslt_f pen
5758: where prv.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
5759: and prv.acty_base_rt_id = l_acty_base_rt_id
5760: and prv.prtt_rt_val_stat_cd is null
5761: and prv.business_group_id = p_business_group_id

Line 6384: from ben_prtt_enrt_rslt_f pen

6380: l_prv_child_rec c_prv_child%rowtype;
6381: --
6382: cursor c_pen is
6383: select pen.*
6384: from ben_prtt_enrt_rslt_f pen
6385: where pen.prtt_enrt_rslt_id = p_flex_rslt_id
6386: and pen.business_group_id = p_business_group_id
6387: and p_effective_date
6388: between pen.effective_start_date and

Line 6800: from ben_prtt_enrt_rslt_f enrt_pen,

6796: bpl.object_version_number,
6797: bpl.effective_start_date,
6798: bpl.bnft_prvdr_pool_id,
6799: bpl.prtt_enrt_rslt_id
6800: from ben_prtt_enrt_rslt_f enrt_pen,
6801: ben_prtt_rt_val enrt_prv,
6802: ben_bnft_prvdd_ldgr_f bpl,
6803: ben_per_in_ler pil,
6804: ben_prtt_enrt_rslt_f flex_pen

Line 6804: ben_prtt_enrt_rslt_f flex_pen

6800: from ben_prtt_enrt_rslt_f enrt_pen,
6801: ben_prtt_rt_val enrt_prv,
6802: ben_bnft_prvdd_ldgr_f bpl,
6803: ben_per_in_ler pil,
6804: ben_prtt_enrt_rslt_f flex_pen
6805: where enrt_pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6806: and enrt_pen.prtt_enrt_rslt_stat_cd is null
6807: and enrt_pen.enrt_cvg_thru_dt = hr_api.g_eot
6808: and p_effective_date between

Line 6844: from ben_prtt_enrt_rslt_f flex_pen,

6840: bpp.bnft_prvdr_pool_id,
6841: bpl.prvdd_val,
6842: bpl.prtt_enrt_rslt_id,
6843: bpp.uses_net_crs_mthd_flag
6844: from ben_prtt_enrt_rslt_f flex_pen,
6845: ben_bnft_prvdd_ldgr_f bpl,
6846: ben_per_in_ler pil,
6847: ben_bnft_prvdr_pool_f bpp
6848: where flex_pen.person_id = p_person_id

Line 6926: ,ben_prtt_enrt_rslt_f pen

6922: --
6923: cursor c_abr(p_acty_typ_cd in varchar2) is
6924: select abr.acty_base_rt_id
6925: from ben_acty_base_rt_f abr
6926: ,ben_prtt_enrt_rslt_f pen
6927: where abr.pl_id = pen.pl_id
6928: and pen.prtt_enrt_rslt_id = l_flex_rslt_id
6929: and abr.business_group_id = p_business_group_id
6930: and pen.business_group_id = abr.business_group_id