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_ENROLMENT_REQUIREMENTS dependencies on BEN_OIPL_F

Line 581: ,p_oipl_rec in ben_oipl_f%rowtype

577: -- internal version below for update_defaults
578: -- bug 5644451. Move at top of the package
579: procedure determine_dflt_enrt_cd
580: (p_oipl_id in number
581: ,p_oipl_rec in ben_oipl_f%rowtype
582: ,p_plip_id in number
583: ,p_plip_rec in ben_plip_f%rowtype
584: ,p_pl_id in number
585: ,p_pl_rec in ben_pl_f%rowtype

Line 707: -- 6 if oipl ben_oipl_f (from cache)

703: -- 3 if pgm ben_ler_chg_plip_enrt_f
704: -- 4 if pgm ben_ler_chg_ptip_enrt_f
705: -- 5 if pgm ben_ler_chg_pgm_enrt_f
706: --
707: -- 6 if oipl ben_oipl_f (from cache)
708:
709: -- 7 if no pgm ben_pl_f
710: -- 8 if pgm ben_plip_f
711: -- 9 if pgm ben_ptip_f

Line 1473: FROM ben_prtt_enrt_rslt_f pen, ben_pl_f pl, ben_oipl_f oipl

1469: --
1470: -- --
1471: CURSOR c_enrolled_opts_in_pl_typ IS
1472: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
1473: FROM ben_prtt_enrt_rslt_f pen, ben_pl_f pl, ben_oipl_f oipl
1474: WHERE pen.person_id = p_person_id
1475: AND pen.business_group_id = p_business_group_id
1476: AND pen.effective_end_date = hr_api.g_eot
1477: AND l_lf_evt_ocrd_dt_1 BETWEEN pen.enrt_cvg_strt_dt

Line 1505: ben_oipl_f oipl,

1501: CURSOR c_cvrd_opts_in_pl_typ IS
1502: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
1503: FROM ben_prtt_enrt_rslt_f pen,
1504: ben_pl_f pl,
1505: ben_oipl_f oipl,
1506: ben_elig_cvrd_dpnt_f pdp
1507: WHERE pdp.dpnt_person_id = p_person_id
1508: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
1509: AND pen.effective_end_date = hr_api.g_eot

Line 2707: l_mn_ordr_num ben_oipl_f.ordr_num%TYPE;

2703: l_enrt_ovridn_flag VARCHAR2(30);
2704: l_enrt_ovrid_thru_dt DATE;
2705: l_oipl_ordr_num NUMBER;
2706: l_boo_rstrctn_cd VARCHAR2(30);
2707: l_mn_ordr_num ben_oipl_f.ordr_num%TYPE;
2708: l_mx_ordr_num ben_oipl_f.ordr_num%TYPE;
2709: l_enrd_ordr_num NUMBER;
2710: l_level VARCHAR2(30);
2711: l_plan_rec ben_pl_f%ROWTYPE;

Line 2708: l_mx_ordr_num ben_oipl_f.ordr_num%TYPE;

2704: l_enrt_ovrid_thru_dt DATE;
2705: l_oipl_ordr_num NUMBER;
2706: l_boo_rstrctn_cd VARCHAR2(30);
2707: l_mn_ordr_num ben_oipl_f.ordr_num%TYPE;
2708: l_mx_ordr_num ben_oipl_f.ordr_num%TYPE;
2709: l_enrd_ordr_num NUMBER;
2710: l_level VARCHAR2(30);
2711: l_plan_rec ben_pl_f%ROWTYPE;
2712: l_pgm_rec ben_pgm_f%ROWTYPE;

Line 2757: l_oipl_record ben_oipl_f%ROWTYPE;

2753: l_fonm_cvg_strt_dt date;
2754: l_epe_exists number ;
2755: --
2756: -- bug: 5644451
2757: l_oipl_record ben_oipl_f%ROWTYPE;
2758: l_plip_record ben_plip_f%ROWTYPE;
2759: l_ptip_record ben_ptip_f%ROWTYPE;
2760: l_dflt_level varchar2(30);
2761: --

Line 3348: FROM ben_oipl_f cop

3344: -- Returns one row if any oipls exist for the plan
3345: --
3346: CURSOR c_any_oipl_for_plan IS -- oipl exists
3347: SELECT NULL
3348: FROM ben_oipl_f cop
3349: WHERE cop.pl_id = l_pl_id
3350: AND business_group_id = p_business_group_id
3351: AND l_lf_evt_ocrd_dt BETWEEN cop.effective_start_date
3352: AND cop.effective_end_date;

Line 3365: FROM ben_oipl_f oipl, ben_ler_bnft_rstrn_f lbr, ben_plip_f plip

3361: plip.bnft_or_option_rstrctn_cd,
3362: lbr.cvg_incr_r_decr_only_cd,
3363: lbr.mx_cvg_mlt_incr_num,
3364: lbr.mx_cvg_mlt_incr_wcf_num
3365: FROM ben_oipl_f oipl, ben_ler_bnft_rstrn_f lbr, ben_plip_f plip
3366: WHERE plip.plip_id = l_plip_id
3367: AND plip.business_group_id = p_business_group_id
3368: AND plip.bnft_or_option_rstrctn_cd = 'OPT'
3369: AND l_lf_evt_ocrd_dt BETWEEN plip.effective_start_date

Line 3389: FROM ben_oipl_f oipl, ben_ler_bnft_rstrn_f lbr, ben_pl_f pl

3385: pl.bnft_or_option_rstrctn_cd,
3386: lbr.cvg_incr_r_decr_only_cd,
3387: lbr.mx_cvg_mlt_incr_num,
3388: lbr.mx_cvg_mlt_incr_wcf_num
3389: FROM ben_oipl_f oipl, ben_ler_bnft_rstrn_f lbr, ben_pl_f pl
3390: WHERE pl.pl_id = l_pl_id
3391: AND pl.business_group_id = p_business_group_id
3392: AND l_lf_evt_ocrd_dt BETWEEN pl.effective_start_date
3393: AND pl.effective_end_date

Line 3418: FROM ben_oipl_f oipl, ben_plip_f plip

3414: plip.bnft_or_option_rstrctn_cd,
3415: plip.cvg_incr_r_decr_only_cd,
3416: plip.mx_cvg_mlt_incr_num,
3417: plip.mx_cvg_mlt_incr_wcf_num
3418: FROM ben_oipl_f oipl, ben_plip_f plip
3419: WHERE plip.plip_id = l_plip_id
3420: AND plip.bnft_or_option_rstrctn_cd = 'OPT'
3421: AND plip.business_group_id = p_business_group_id
3422: AND l_lf_evt_ocrd_dt BETWEEN plip.effective_start_date

Line 3437: FROM ben_oipl_f oipl, ben_pl_f pl

3433: pl.bnft_or_option_rstrctn_cd,
3434: pl.cvg_incr_r_decr_only_cd,
3435: pl.mx_cvg_mlt_incr_num,
3436: pl.mx_cvg_mlt_incr_wcf_num
3437: FROM ben_oipl_f oipl, ben_pl_f pl
3438: WHERE pl.pl_id = l_pl_id
3439: AND pl.bnft_or_option_rstrctn_cd = 'OPT'
3440: AND pl.business_group_id = p_business_group_id
3441: AND l_lf_evt_ocrd_dt BETWEEN pl.effective_start_date

Line 3457: FROM ben_prtt_enrt_rslt_f pen, ben_oipl_f enrd_oipl

3453: --
3454: --
3455: CURSOR c_oipl_enrt_in_pl IS
3456: SELECT enrd_oipl.ordr_num
3457: FROM ben_prtt_enrt_rslt_f pen, ben_oipl_f enrd_oipl
3458: WHERE
3459: -- get result for plan if exists
3460: pen.person_id = p_person_id
3461: AND pen.business_group_id = p_business_group_id

Line 3481: ben_oipl_f enrd_oipl

3477: CURSOR c_oipl_cvg_in_pl IS
3478: SELECT enrd_oipl.ordr_num
3479: FROM ben_prtt_enrt_rslt_f pen,
3480: ben_elig_cvrd_dpnt_f pdp,
3481: ben_oipl_f enrd_oipl
3482: WHERE pdp.dpnt_person_id = p_person_id
3483: AND pdp.effective_end_date = hr_api.g_eot
3484: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
3485: AND pdp.business_group_id = p_business_group_id

Line 3505: FROM ben_oipl_f cop

3501: --
3502: CURSOR c_get_min_max_ordr_num IS
3503: SELECT MIN(cop.ordr_num),
3504: MAX(cop.ordr_num)
3505: FROM ben_oipl_f cop
3506: WHERE cop.pl_id = l_pl_id
3507: AND l_lf_evt_ocrd_dt BETWEEN cop.effective_start_date
3508: AND cop.effective_end_date
3509: AND cop.business_group_id = p_business_group_id;

Line 3560: from ben_oipl_f oipl

3556: ;
3557: --
3558: cursor c_oipl_requery(p_id number,p_ed date) is
3559: select 'Y'
3560: from ben_oipl_f oipl
3561: where oipl_id=p_id and
3562: business_group_id=p_business_group_id and
3563: p_ed between effective_start_date and effective_end_date
3564: ;

Line 3615: from ben_oipl_f oipl,

3611: l_effective_start_date date;
3612: --
3613: cursor c_opt_level is
3614: select oipl2.ordr_num
3615: from ben_oipl_f oipl,
3616: ben_oipl_f oipl2
3617: where oipl.oipl_id = p_oipl_id
3618: and oipl.pl_id = oipl2.pl_id
3619: and oipl2.oipl_stat_cd = 'A'

Line 3616: ben_oipl_f oipl2

3612: --
3613: cursor c_opt_level is
3614: select oipl2.ordr_num
3615: from ben_oipl_f oipl,
3616: ben_oipl_f oipl2
3617: where oipl.oipl_id = p_oipl_id
3618: and oipl.pl_id = oipl2.pl_id
3619: and oipl2.oipl_stat_cd = 'A'
3620: and oipl.business_group_id = p_business_group_id

Line 8822: -- 2 if oipl ben_oipl_f (from cache)

8818: --
8819: -- Hierarchy
8820: --
8821: -- 1 if oipl ben_ler_chg_oipl_enrt_f
8822: -- 2 if oipl ben_oipl_f (from cache)
8823: --
8824: -- 3 if no pgm ben_ler_chg_pl_nip_enrt_f
8825: -- 4 if pgm ben_ler_chg_plip_enrt_f
8826: -- 4.5 if pgm ben_ler_chg_pl_nip_enrt_f

Line 8970: ,p_oipl_rec in ben_oipl_f%rowtype

8966: -- internal version below for update_defaults
8967: --
8968: procedure determine_dflt_enrt_cd
8969: (p_oipl_id in number
8970: ,p_oipl_rec in ben_oipl_f%rowtype
8971: ,p_plip_id in number
8972: ,p_plip_rec in ben_plip_f%rowtype
8973: ,p_pl_id in number
8974: ,p_pl_rec in ben_pl_f%rowtype

Line 9085: -- 2 if oipl ben_oipl_f (from cache)

9081: --
9082: -- Hierarchy
9083: --
9084: -- 1 if oipl ben_ler_chg_oipl_enrt_f
9085: -- 2 if oipl ben_oipl_f (from cache)
9086: --
9087: -- 3 if no pgm ben_ler_chg_pl_nip_enrt_f
9088: -- 4 if pgm ben_ler_chg_plip_enrt_f
9089: -- 5 if pgm ben_ler_chg_ptip_enrt_f

Line 9365: FROM ben_oipl_f bo

9361: SELECT '1',
9362: bo.rqd_perd_enrt_nenrt_uom,
9363: bo.rqd_perd_enrt_nenrt_val,
9364: bo.rqd_perd_enrt_nenrt_rl
9365: FROM ben_oipl_f bo
9366: WHERE bo.oipl_id = p_oipl_id
9367: AND p_effective_date BETWEEN bo.effective_start_date
9368: AND bo.effective_end_date
9369: AND bo.business_group_id = p_business_group_id

Line 9608: FROM ben_prtt_enrt_rslt_f pen, ben_pl_f pl, ben_oipl_f oipl

9604: -- Gets the enrolment information for the opt
9605: --
9606: CURSOR c_opt_enrolment_info IS
9607: SELECT pen.*
9608: FROM ben_prtt_enrt_rslt_f pen, ben_pl_f pl, ben_oipl_f oipl
9609: WHERE pen.person_id = p_person_id
9610: AND pen.business_group_id = p_business_group_id
9611: AND pen.effective_end_date = hr_api.g_eot
9612: AND l_effective_date_1 BETWEEN pen.enrt_cvg_strt_dt

Line 9693: l_oipl_rec ben_oipl_f%rowtype;

9689: l_rec_assignment_id number;
9690: l_rec_organization_id number;
9691: l_dflt_flag varchar2(30);
9692: l_use_dflt_flag varchar2(30);
9693: l_oipl_rec ben_oipl_f%rowtype;
9694: l_empty_oipl ben_oipl_f%rowtype;
9695: l_plan_rec ben_pl_f%rowtype;
9696: l_pgm_rec ben_pgm_f%rowtype;
9697: l_empty_pgm ben_pgm_f%rowtype;

Line 9694: l_empty_oipl ben_oipl_f%rowtype;

9690: l_rec_organization_id number;
9691: l_dflt_flag varchar2(30);
9692: l_use_dflt_flag varchar2(30);
9693: l_oipl_rec ben_oipl_f%rowtype;
9694: l_empty_oipl ben_oipl_f%rowtype;
9695: l_plan_rec ben_pl_f%rowtype;
9696: l_pgm_rec ben_pgm_f%rowtype;
9697: l_empty_pgm ben_pgm_f%rowtype;
9698: l_plip_rec ben_plip_f%rowtype;

Line 9749: from ben_oipl_f oipl

9745: and invk_flx_cr_pl_flag='N'
9746: and (epe.oipl_id is not null or
9747: not exists
9748: (select null
9749: from ben_oipl_f oipl
9750: where c_lf_evt_ocrd_dt
9751: between oipl.effective_start_date and oipl.effective_end_date
9752: and oipl.pl_id=epe.pl_id
9753: )