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 554: ,p_oipl_rec in ben_oipl_f%rowtype

550: -- internal version below for update_defaults
551: -- bug 5644451. Move at top of the package
552: procedure determine_dflt_enrt_cd
553: (p_oipl_id in number
554: ,p_oipl_rec in ben_oipl_f%rowtype
555: ,p_plip_id in number
556: ,p_plip_rec in ben_plip_f%rowtype
557: ,p_pl_id in number
558: ,p_pl_rec in ben_pl_f%rowtype

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

676: -- 3 if pgm ben_ler_chg_plip_enrt_f
677: -- 4 if pgm ben_ler_chg_ptip_enrt_f
678: -- 5 if pgm ben_ler_chg_pgm_enrt_f
679: --
680: -- 6 if oipl ben_oipl_f (from cache)
681:
682: -- 7 if no pgm ben_pl_f
683: -- 8 if pgm ben_plip_f
684: -- 9 if pgm ben_ptip_f

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

1442: --
1443: -- --
1444: CURSOR c_enrolled_opts_in_pl_typ IS
1445: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
1446: FROM ben_prtt_enrt_rslt_f pen, ben_pl_f pl, ben_oipl_f oipl
1447: WHERE pen.person_id = p_person_id
1448: AND pen.business_group_id = p_business_group_id
1449: AND pen.effective_end_date = hr_api.g_eot
1450: AND l_lf_evt_ocrd_dt_1 BETWEEN pen.enrt_cvg_strt_dt

Line 1478: ben_oipl_f oipl,

1474: CURSOR c_cvrd_opts_in_pl_typ IS
1475: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
1476: FROM ben_prtt_enrt_rslt_f pen,
1477: ben_pl_f pl,
1478: ben_oipl_f oipl,
1479: ben_elig_cvrd_dpnt_f pdp
1480: WHERE pdp.dpnt_person_id = p_person_id
1481: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
1482: AND pen.effective_end_date = hr_api.g_eot

Line 2680: l_mn_ordr_num ben_oipl_f.ordr_num%TYPE;

2676: l_enrt_ovridn_flag VARCHAR2(30);
2677: l_enrt_ovrid_thru_dt DATE;
2678: l_oipl_ordr_num NUMBER;
2679: l_boo_rstrctn_cd VARCHAR2(30);
2680: l_mn_ordr_num ben_oipl_f.ordr_num%TYPE;
2681: l_mx_ordr_num ben_oipl_f.ordr_num%TYPE;
2682: l_enrd_ordr_num NUMBER;
2683: l_level VARCHAR2(30);
2684: l_plan_rec ben_pl_f%ROWTYPE;

Line 2681: l_mx_ordr_num ben_oipl_f.ordr_num%TYPE;

2677: l_enrt_ovrid_thru_dt DATE;
2678: l_oipl_ordr_num NUMBER;
2679: l_boo_rstrctn_cd VARCHAR2(30);
2680: l_mn_ordr_num ben_oipl_f.ordr_num%TYPE;
2681: l_mx_ordr_num ben_oipl_f.ordr_num%TYPE;
2682: l_enrd_ordr_num NUMBER;
2683: l_level VARCHAR2(30);
2684: l_plan_rec ben_pl_f%ROWTYPE;
2685: l_pgm_rec ben_pgm_f%ROWTYPE;

Line 2730: l_oipl_record ben_oipl_f%ROWTYPE;

2726: l_fonm_cvg_strt_dt date;
2727: l_epe_exists number ;
2728: --
2729: -- bug: 5644451
2730: l_oipl_record ben_oipl_f%ROWTYPE;
2731: l_plip_record ben_plip_f%ROWTYPE;
2732: l_ptip_record ben_ptip_f%ROWTYPE;
2733: l_dflt_level varchar2(30);
2734: --

Line 3302: FROM ben_oipl_f cop

3298: -- Returns one row if any oipls exist for the plan
3299: --
3300: CURSOR c_any_oipl_for_plan IS -- oipl exists
3301: SELECT NULL
3302: FROM ben_oipl_f cop
3303: WHERE cop.pl_id = l_pl_id
3304: AND business_group_id = p_business_group_id
3305: AND l_lf_evt_ocrd_dt BETWEEN cop.effective_start_date
3306: AND cop.effective_end_date;

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

3315: plip.bnft_or_option_rstrctn_cd,
3316: lbr.cvg_incr_r_decr_only_cd,
3317: lbr.mx_cvg_mlt_incr_num,
3318: lbr.mx_cvg_mlt_incr_wcf_num
3319: FROM ben_oipl_f oipl, ben_ler_bnft_rstrn_f lbr, ben_plip_f plip
3320: WHERE plip.plip_id = l_plip_id
3321: AND plip.business_group_id = p_business_group_id
3322: AND plip.bnft_or_option_rstrctn_cd = 'OPT'
3323: AND l_lf_evt_ocrd_dt BETWEEN plip.effective_start_date

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

3339: pl.bnft_or_option_rstrctn_cd,
3340: lbr.cvg_incr_r_decr_only_cd,
3341: lbr.mx_cvg_mlt_incr_num,
3342: lbr.mx_cvg_mlt_incr_wcf_num
3343: FROM ben_oipl_f oipl, ben_ler_bnft_rstrn_f lbr, ben_pl_f pl
3344: WHERE pl.pl_id = l_pl_id
3345: AND pl.business_group_id = p_business_group_id
3346: AND l_lf_evt_ocrd_dt BETWEEN pl.effective_start_date
3347: AND pl.effective_end_date

Line 3372: FROM ben_oipl_f oipl, ben_plip_f plip

3368: plip.bnft_or_option_rstrctn_cd,
3369: plip.cvg_incr_r_decr_only_cd,
3370: plip.mx_cvg_mlt_incr_num,
3371: plip.mx_cvg_mlt_incr_wcf_num
3372: FROM ben_oipl_f oipl, ben_plip_f plip
3373: WHERE plip.plip_id = l_plip_id
3374: AND plip.bnft_or_option_rstrctn_cd = 'OPT'
3375: AND plip.business_group_id = p_business_group_id
3376: AND l_lf_evt_ocrd_dt BETWEEN plip.effective_start_date

Line 3391: FROM ben_oipl_f oipl, ben_pl_f pl

3387: pl.bnft_or_option_rstrctn_cd,
3388: pl.cvg_incr_r_decr_only_cd,
3389: pl.mx_cvg_mlt_incr_num,
3390: pl.mx_cvg_mlt_incr_wcf_num
3391: FROM ben_oipl_f oipl, ben_pl_f pl
3392: WHERE pl.pl_id = l_pl_id
3393: AND pl.bnft_or_option_rstrctn_cd = 'OPT'
3394: AND pl.business_group_id = p_business_group_id
3395: AND l_lf_evt_ocrd_dt BETWEEN pl.effective_start_date

Line 3411: FROM ben_prtt_enrt_rslt_f pen, ben_oipl_f enrd_oipl

3407: --
3408: --
3409: CURSOR c_oipl_enrt_in_pl IS
3410: SELECT enrd_oipl.ordr_num
3411: FROM ben_prtt_enrt_rslt_f pen, ben_oipl_f enrd_oipl
3412: WHERE
3413: -- get result for plan if exists
3414: pen.person_id = p_person_id
3415: AND pen.business_group_id = p_business_group_id

Line 3435: ben_oipl_f enrd_oipl

3431: CURSOR c_oipl_cvg_in_pl IS
3432: SELECT enrd_oipl.ordr_num
3433: FROM ben_prtt_enrt_rslt_f pen,
3434: ben_elig_cvrd_dpnt_f pdp,
3435: ben_oipl_f enrd_oipl
3436: WHERE pdp.dpnt_person_id = p_person_id
3437: AND pdp.effective_end_date = hr_api.g_eot
3438: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
3439: AND pdp.business_group_id = p_business_group_id

Line 3459: FROM ben_oipl_f cop

3455: --
3456: CURSOR c_get_min_max_ordr_num IS
3457: SELECT MIN(cop.ordr_num),
3458: MAX(cop.ordr_num)
3459: FROM ben_oipl_f cop
3460: WHERE cop.pl_id = l_pl_id
3461: AND l_lf_evt_ocrd_dt BETWEEN cop.effective_start_date
3462: AND cop.effective_end_date
3463: AND cop.business_group_id = p_business_group_id;

Line 3514: from ben_oipl_f oipl

3510: ;
3511: --
3512: cursor c_oipl_requery(p_id number,p_ed date) is
3513: select 'Y'
3514: from ben_oipl_f oipl
3515: where oipl_id=p_id and
3516: business_group_id=p_business_group_id and
3517: p_ed between effective_start_date and effective_end_date
3518: ;

Line 3569: from ben_oipl_f oipl,

3565: l_effective_start_date date;
3566: --
3567: cursor c_opt_level is
3568: select oipl2.ordr_num
3569: from ben_oipl_f oipl,
3570: ben_oipl_f oipl2
3571: where oipl.oipl_id = p_oipl_id
3572: and oipl.pl_id = oipl2.pl_id
3573: and oipl2.oipl_stat_cd = 'A'

Line 3570: ben_oipl_f oipl2

3566: --
3567: cursor c_opt_level is
3568: select oipl2.ordr_num
3569: from ben_oipl_f oipl,
3570: ben_oipl_f oipl2
3571: where oipl.oipl_id = p_oipl_id
3572: and oipl.pl_id = oipl2.pl_id
3573: and oipl2.oipl_stat_cd = 'A'
3574: and oipl.business_group_id = p_business_group_id

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

8679: --
8680: -- Hierarchy
8681: --
8682: -- 1 if oipl ben_ler_chg_oipl_enrt_f
8683: -- 2 if oipl ben_oipl_f (from cache)
8684: --
8685: -- 3 if no pgm ben_ler_chg_pl_nip_enrt_f
8686: -- 4 if pgm ben_ler_chg_plip_enrt_f
8687: -- 4.5 if pgm ben_ler_chg_pl_nip_enrt_f

Line 8831: ,p_oipl_rec in ben_oipl_f%rowtype

8827: -- internal version below for update_defaults
8828: --
8829: procedure determine_dflt_enrt_cd
8830: (p_oipl_id in number
8831: ,p_oipl_rec in ben_oipl_f%rowtype
8832: ,p_plip_id in number
8833: ,p_plip_rec in ben_plip_f%rowtype
8834: ,p_pl_id in number
8835: ,p_pl_rec in ben_pl_f%rowtype

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

8942: --
8943: -- Hierarchy
8944: --
8945: -- 1 if oipl ben_ler_chg_oipl_enrt_f
8946: -- 2 if oipl ben_oipl_f (from cache)
8947: --
8948: -- 3 if no pgm ben_ler_chg_pl_nip_enrt_f
8949: -- 4 if pgm ben_ler_chg_plip_enrt_f
8950: -- 5 if pgm ben_ler_chg_ptip_enrt_f

Line 9226: FROM ben_oipl_f bo

9222: SELECT '1',
9223: bo.rqd_perd_enrt_nenrt_uom,
9224: bo.rqd_perd_enrt_nenrt_val,
9225: bo.rqd_perd_enrt_nenrt_rl
9226: FROM ben_oipl_f bo
9227: WHERE bo.oipl_id = p_oipl_id
9228: AND p_effective_date BETWEEN bo.effective_start_date
9229: AND bo.effective_end_date
9230: AND bo.business_group_id = p_business_group_id

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

9462: -- Gets the enrolment information for the opt
9463: --
9464: CURSOR c_opt_enrolment_info IS
9465: SELECT pen.*
9466: FROM ben_prtt_enrt_rslt_f pen, ben_pl_f pl, ben_oipl_f oipl
9467: WHERE pen.person_id = p_person_id
9468: AND pen.business_group_id = p_business_group_id
9469: AND pen.effective_end_date = hr_api.g_eot
9470: AND l_effective_date_1 BETWEEN pen.enrt_cvg_strt_dt

Line 9551: l_oipl_rec ben_oipl_f%rowtype;

9547: l_rec_assignment_id number;
9548: l_rec_organization_id number;
9549: l_dflt_flag varchar2(30);
9550: l_use_dflt_flag varchar2(30);
9551: l_oipl_rec ben_oipl_f%rowtype;
9552: l_empty_oipl ben_oipl_f%rowtype;
9553: l_plan_rec ben_pl_f%rowtype;
9554: l_pgm_rec ben_pgm_f%rowtype;
9555: l_empty_pgm ben_pgm_f%rowtype;

Line 9552: l_empty_oipl ben_oipl_f%rowtype;

9548: l_rec_organization_id number;
9549: l_dflt_flag varchar2(30);
9550: l_use_dflt_flag varchar2(30);
9551: l_oipl_rec ben_oipl_f%rowtype;
9552: l_empty_oipl ben_oipl_f%rowtype;
9553: l_plan_rec ben_pl_f%rowtype;
9554: l_pgm_rec ben_pgm_f%rowtype;
9555: l_empty_pgm ben_pgm_f%rowtype;
9556: l_plip_rec ben_plip_f%rowtype;

Line 9607: from ben_oipl_f oipl

9603: and invk_flx_cr_pl_flag='N'
9604: and (epe.oipl_id is not null or
9605: not exists
9606: (select null
9607: from ben_oipl_f oipl
9608: where c_lf_evt_ocrd_dt
9609: between oipl.effective_start_date and oipl.effective_end_date
9610: and oipl.pl_id=epe.pl_id
9611: )