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_EVALUATE_RATE_PROFILES dependencies on BEN_MANAGE_LIFE_EVENTS

Line 458: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)

454: ,p_param1 => 'BEN_VPF_I_VRBL_RT_PRFL_ID'
455: ,p_param1_value => to_char(nvl(p_vrbl_rt_prfl_id, -1))
456: -- FONM
457: ,p_param2 => 'BEN_IV_RT_STRT_DT'
458: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
459: ,p_param3 => 'BEN_IV_CVG_STRT_DT'
460: ,p_param3_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)
461: );
462: -- if the profile is AND and one of the rule fails #2508757

Line 460: ,p_param3_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)

456: -- FONM
457: ,p_param2 => 'BEN_IV_RT_STRT_DT'
458: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
459: ,p_param3 => 'BEN_IV_CVG_STRT_DT'
460: ,p_param3_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt)
461: );
462: -- if the profile is AND and one of the rule fails #2508757
463: if nvl(l_ben_vapro_rul_cond,'A') = 'A' then
464:

Line 1378: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),

1374: (p_formula_id => l_inst_dets(l_count).formula_id,
1375: p_assignment_id => l_ass_rec.assignment_id,
1376: p_effective_date => nvl(p_lf_evt_ocrd_dt, p_effective_date), -- FONM
1377: p_param1 => 'BEN_IV_RT_STRT_DT',
1378: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1379: p_param2 => 'BEN_IV_CVG_STRT_DT',
1380: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1381: --
1382: begin

Line 1380: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));

1376: p_effective_date => nvl(p_lf_evt_ocrd_dt, p_effective_date), -- FONM
1377: p_param1 => 'BEN_IV_RT_STRT_DT',
1378: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1379: p_param2 => 'BEN_IV_CVG_STRT_DT',
1380: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1381: --
1382: begin
1383: --
1384: if l_outputs(l_outputs.first).name = 'INCLUDE_FLAG' then

Line 1843: if ben_manage_life_events.fonm = 'Y' then

1839: --
1840: if l_inst_count > 0 then
1841: --
1842: -- FONM
1843: if ben_manage_life_events.fonm = 'Y' then
1844: --
1845: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
1846: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
1847: nvl(p_lf_evt_ocrd_dt, p_effective_date)));

Line 1845: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

1841: --
1842: -- FONM
1843: if ben_manage_life_events.fonm = 'Y' then
1844: --
1845: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
1846: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
1847: nvl(p_lf_evt_ocrd_dt, p_effective_date)));
1848: else
1849: --

Line 1846: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

1842: -- FONM
1843: if ben_manage_life_events.fonm = 'Y' then
1844: --
1845: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
1846: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
1847: nvl(p_lf_evt_ocrd_dt, p_effective_date)));
1848: else
1849: --
1850: l_effective_date := nvl(p_lf_evt_ocrd_dt, p_effective_date);

Line 2142: if ben_manage_life_events.fonm = 'Y' then

2138: -- Get the data from the cache.
2139: hr_utility.set_location('entering chck_zip_code', 10);
2140: --
2141: -- FONM
2142: if ben_manage_life_events.fonm = 'Y' then
2143: --
2144: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2145: ben_manage_life_events.g_fonm_cvg_strt_dt);
2146: --

Line 2144: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

2140: --
2141: -- FONM
2142: if ben_manage_life_events.fonm = 'Y' then
2143: --
2144: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2145: ben_manage_life_events.g_fonm_cvg_strt_dt);
2146: --
2147: end if;
2148: --

Line 2145: ben_manage_life_events.g_fonm_cvg_strt_dt);

2141: -- FONM
2142: if ben_manage_life_events.fonm = 'Y' then
2143: --
2144: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2145: ben_manage_life_events.g_fonm_cvg_strt_dt);
2146: --
2147: end if;
2148: --
2149: -- FONM

Line 2462: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)

2458: ,p_opt_id => p_opt_id
2459: ,p_ler_id => p_ler_id
2460: ,p_jurisdiction_code => p_jurisdiction_code -- FONM
2461: ,p_param1 => 'BEN_IV_RT_STRT_DT'
2462: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
2463: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
2464: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
2465:
2466: --

Line 2464: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));

2460: ,p_jurisdiction_code => p_jurisdiction_code -- FONM
2461: ,p_param1 => 'BEN_IV_RT_STRT_DT'
2462: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
2463: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
2464: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
2465:
2466: --
2467: for l_count in l_output.first..l_output.last loop
2468: --

Line 2551: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

2547: p_business_group_id => p_business_group_id,
2548: p_formula_id => l_inst_set(i).determination_rl,
2549: p_effective_date => p_effective_date,
2550: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
2551: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
2552: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
2553: p_returned_date => l_det_dt );
2554: end if;
2555:

Line 2552: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

2548: p_formula_id => l_inst_set(i).determination_rl,
2549: p_effective_date => p_effective_date,
2550: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
2551: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
2552: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
2553: p_returned_date => l_det_dt );
2554: end if;
2555:
2556:

Line 2563: l_det_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

2559:
2560: --
2561: if l_det_dt is null then
2562: -- FONM
2563: l_det_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2564: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2565: nvl(p_lf_evt_ocrd_dt,p_effective_date)));
2566: end if;
2567:

Line 2564: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

2560: --
2561: if l_det_dt is null then
2562: -- FONM
2563: l_det_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2564: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2565: nvl(p_lf_evt_ocrd_dt,p_effective_date)));
2566: end if;
2567:
2568: -- get Scheduled hour details from the assignment records

Line 2790: if ben_manage_life_events.fonm = 'Y' then

2786: BEGIN
2787: --
2788: -- FONM
2789: --
2790: if ben_manage_life_events.fonm = 'Y' then
2791: --
2792: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2793: ben_manage_life_events.g_fonm_cvg_strt_dt);
2794: --

Line 2792: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

2788: -- FONM
2789: --
2790: if ben_manage_life_events.fonm = 'Y' then
2791: --
2792: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2793: ben_manage_life_events.g_fonm_cvg_strt_dt);
2794: --
2795: end if;
2796: --

Line 2793: ben_manage_life_events.g_fonm_cvg_strt_dt);

2789: --
2790: if ben_manage_life_events.fonm = 'Y' then
2791: --
2792: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2793: ben_manage_life_events.g_fonm_cvg_strt_dt);
2794: --
2795: end if;
2796: --
2797: -- Get the data from the cache.

Line 2982: if ben_manage_life_events.fonm = 'Y' then

2978: begin
2979: --
2980: --- fonm2
2981: l_effective_date := nvl( p_lf_evt_ocrd_dt, p_effective_date ) ;
2982: if ben_manage_life_events.fonm = 'Y' then
2983: --
2984: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2985: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2986: l_effective_date));

Line 2984: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

2980: --- fonm2
2981: l_effective_date := nvl( p_lf_evt_ocrd_dt, p_effective_date ) ;
2982: if ben_manage_life_events.fonm = 'Y' then
2983: --
2984: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2985: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2986: l_effective_date));
2987: --
2988: end if;

Line 2985: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

2981: l_effective_date := nvl( p_lf_evt_ocrd_dt, p_effective_date ) ;
2982: if ben_manage_life_events.fonm = 'Y' then
2983: --
2984: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2985: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2986: l_effective_date));
2987: --
2988: end if;
2989:

Line 3094: ,p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt

3090: ,p_per_in_ler_id => l_per_in_ler_id
3091: ,p_effective_date => p_effective_date
3092: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
3093: --fonm
3094: ,p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt
3095: ,p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt
3096: ,p_business_group_id => p_business_group_id
3097: ,p_perform_rounding_flg => TRUE
3098: ,p_value => l_per_age

Line 3095: ,p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt

3091: ,p_effective_date => p_effective_date
3092: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
3093: --fonm
3094: ,p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt
3095: ,p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt
3096: ,p_business_group_id => p_business_group_id
3097: ,p_perform_rounding_flg => TRUE
3098: ,p_value => l_per_age
3099: ,p_change_date => l_dummy_date);

Line 3215: if ben_manage_life_events.fonm = 'Y' then

3211: begin
3212: --
3213: --- fonm2
3214: l_effective_date := nvl( p_lf_evt_ocrd_dt, p_effective_date ) ;
3215: if ben_manage_life_events.fonm = 'Y' then
3216: --
3217: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3218: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3219: l_effective_date));

Line 3217: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

3213: --- fonm2
3214: l_effective_date := nvl( p_lf_evt_ocrd_dt, p_effective_date ) ;
3215: if ben_manage_life_events.fonm = 'Y' then
3216: --
3217: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3218: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3219: l_effective_date));
3220: --
3221: end if;

Line 3218: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

3214: l_effective_date := nvl( p_lf_evt_ocrd_dt, p_effective_date ) ;
3215: if ben_manage_life_events.fonm = 'Y' then
3216: --
3217: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3218: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3219: l_effective_date));
3220: --
3221: end if;
3222:

Line 3287: ,p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt

3283: ,p_perform_rounding_flg => true
3284: ,p_effective_date => p_effective_date
3285: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
3286:
3287: ,p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt
3288: ,p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt
3289: ,p_value => l_compensation_value);
3290:
3291: hr_utility.set_location( ' compen ' || l_compensation_value , 610.2) ;

Line 3288: ,p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt

3284: ,p_effective_date => p_effective_date
3285: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
3286:
3287: ,p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt
3288: ,p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt
3289: ,p_value => l_compensation_value);
3290:
3291: hr_utility.set_location( ' compen ' || l_compensation_value , 610.2) ;
3292: hr_utility.set_location( ' mn compen ' || l_inst_set(i).mn_comp_val , 610.2) ;

Line 3412: if ben_manage_life_events.fonm = 'Y' then

3408: --
3409:
3410: --- fonm2
3411: l_effective_date := nvl( p_lf_evt_ocrd_dt, p_effective_date ) ;
3412: if ben_manage_life_events.fonm = 'Y' then
3413: --
3414: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3415: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3416: l_effective_date));

Line 3414: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

3410: --- fonm2
3411: l_effective_date := nvl( p_lf_evt_ocrd_dt, p_effective_date ) ;
3412: if ben_manage_life_events.fonm = 'Y' then
3413: --
3414: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3415: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3416: l_effective_date));
3417: --
3418: end if;

Line 3415: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

3411: l_effective_date := nvl( p_lf_evt_ocrd_dt, p_effective_date ) ;
3412: if ben_manage_life_events.fonm = 'Y' then
3413: --
3414: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3415: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3416: l_effective_date));
3417: --
3418: end if;
3419:

Line 3512: ,p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt

3508: ,p_oipl_id => l_oipl_id
3509: ,p_effective_date => p_effective_date
3510: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
3511: --fonm
3512: ,p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt
3513: ,p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt
3514: ,p_business_group_id => p_business_group_id
3515: ,p_perform_rounding_flg => TRUE
3516: ,p_value => l_per_los

Line 3513: ,p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt

3509: ,p_effective_date => p_effective_date
3510: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
3511: --fonm
3512: ,p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt
3513: ,p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt
3514: ,p_business_group_id => p_business_group_id
3515: ,p_perform_rounding_flg => TRUE
3516: ,p_value => l_per_los
3517: ,p_start_date => l_dummy_date);

Line 3629: if ben_manage_life_events.fonm = 'Y' then

3625: begin
3626: --
3627: --- fonm2
3628: l_effective_date := nvl( p_lf_evt_ocrd_dt, p_effective_date ) ;
3629: if ben_manage_life_events.fonm = 'Y' then
3630: --
3631: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3632: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3633: l_effective_date));

Line 3631: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

3627: --- fonm2
3628: l_effective_date := nvl( p_lf_evt_ocrd_dt, p_effective_date ) ;
3629: if ben_manage_life_events.fonm = 'Y' then
3630: --
3631: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3632: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3633: l_effective_date));
3634: --
3635: end if;

Line 3632: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

3628: l_effective_date := nvl( p_lf_evt_ocrd_dt, p_effective_date ) ;
3629: if ben_manage_life_events.fonm = 'Y' then
3630: --
3631: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3632: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3633: l_effective_date));
3634: --
3635: end if;
3636:

Line 3726: ,p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt

3722: ,p_oipl_id => l_oipl_id
3723: ,p_effective_date => p_effective_date
3724: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
3725: -- fonm
3726: ,p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt
3727: ,p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt
3728: ,p_business_group_id => p_business_group_id
3729: ,p_value => l_cmbn_age_n_los_val);
3730: --

Line 3727: ,p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt

3723: ,p_effective_date => p_effective_date
3724: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
3725: -- fonm
3726: ,p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt
3727: ,p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt
3728: ,p_business_group_id => p_business_group_id
3729: ,p_value => l_cmbn_age_n_los_val);
3730: --
3731: end if;

Line 4425: ,nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

4421: --
4422: l_rows_found := true;
4423: -- FONM
4424: open c1(p_person_id
4425: ,nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
4426: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
4427: nvl(p_lf_evt_ocrd_dt,p_effective_date)))
4428: ,l_inst_set(i).pgm_id
4429: ,l_inst_set(i).ptip_id);

Line 4426: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

4422: l_rows_found := true;
4423: -- FONM
4424: open c1(p_person_id
4425: ,nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
4426: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
4427: nvl(p_lf_evt_ocrd_dt,p_effective_date)))
4428: ,l_inst_set(i).pgm_id
4429: ,l_inst_set(i).ptip_id);
4430: fetch c1 into l_quald_bnf_flag;

Line 4519: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

4515: ben_determine_date.main
4516: (p_date_cd => l_inst_set(i).cvg_det_dt_cd,
4517: p_effective_date => p_effective_date,
4518: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
4519: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
4520: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
4521: p_returned_date => l_date_to_use);
4522: --
4523: open c1(l_inst_set(i).pl_id);

Line 4520: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

4516: (p_date_cd => l_inst_set(i).cvg_det_dt_cd,
4517: p_effective_date => p_effective_date,
4518: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
4519: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
4520: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
4521: p_returned_date => l_date_to_use);
4522: --
4523: open c1(l_inst_set(i).pl_id);
4524: fetch c1 into l_dummy;

Line 4633: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

4629: ben_determine_date.main
4630: (p_date_cd => l_inst_set(i).enrl_det_dt_cd,
4631: p_effective_date => p_effective_date,
4632: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
4633: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
4634: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
4635: p_returned_date => l_date_to_use);
4636: --
4637: open c1(l_inst_set(i).plip_id);

Line 4634: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

4630: (p_date_cd => l_inst_set(i).enrl_det_dt_cd,
4631: p_effective_date => p_effective_date,
4632: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
4633: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
4634: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
4635: p_returned_date => l_date_to_use);
4636: --
4637: open c1(l_inst_set(i).plip_id);
4638: fetch c1 into l_dummy;

Line 4760: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

4756: ben_determine_date.main
4757: (p_date_cd => l_inst_set(i).enrl_det_dt_cd,
4758: p_effective_date => p_effective_date,
4759: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
4760: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
4761: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
4762: p_returned_date => l_date_to_use);
4763: --
4764: <>

Line 4761: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

4757: (p_date_cd => l_inst_set(i).enrl_det_dt_cd,
4758: p_effective_date => p_effective_date,
4759: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
4760: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
4761: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
4762: p_returned_date => l_date_to_use);
4763: --
4764: <>
4765: for l_pdp_rec in c1(l_inst_set(i).ptip_id) loop

Line 4882: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

4878: ben_determine_date.main
4879: (p_date_cd => l_inst_set(i).enrl_det_dt_cd,
4880: p_effective_date => p_effective_date,
4881: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
4882: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
4883: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
4884: p_returned_date => l_date_to_use);
4885: --
4886: open c1(l_inst_set(i).pgm_id);

Line 4883: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

4879: (p_date_cd => l_inst_set(i).enrl_det_dt_cd,
4880: p_effective_date => p_effective_date,
4881: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
4882: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
4883: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
4884: p_returned_date => l_date_to_use);
4885: --
4886: open c1(l_inst_set(i).pgm_id);
4887: fetch c1 into l_dummy;

Line 5184: (c_effective_date => nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

5180: --
5181: if p_per_in_ler_id is not null then
5182: --
5183: open pilc1
5184: (c_effective_date => nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
5185: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
5186: nvl(p_lf_evt_ocrd_dt,p_effective_date)))
5187: ,c_per_in_ler_id => p_per_in_ler_id
5188: ,c_ptip_id => l_inst_set(i).ptip_id

Line 5185: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

5181: if p_per_in_ler_id is not null then
5182: --
5183: open pilc1
5184: (c_effective_date => nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
5185: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
5186: nvl(p_lf_evt_ocrd_dt,p_effective_date)))
5187: ,c_per_in_ler_id => p_per_in_ler_id
5188: ,c_ptip_id => l_inst_set(i).ptip_id
5189: ,c_only_pls_subj_cobra_flag => l_inst_set(i).only_pls_subj_cobra_flag

Line 5207: ,c_effective_date => nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

5203: else
5204: --
5205: open c1
5206: (c_business_group_id => p_business_group_id
5207: ,c_effective_date => nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
5208: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date)))
5209: ,c_person_id => p_person_id
5210: ,c_ptip_id => l_inst_set(i).ptip_id
5211: ,c_only_pls_subj_cobra_flag => l_inst_set(i).only_pls_subj_cobra_flag

Line 5208: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date)))

5204: --
5205: open c1
5206: (c_business_group_id => p_business_group_id
5207: ,c_effective_date => nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
5208: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date)))
5209: ,c_person_id => p_person_id
5210: ,c_ptip_id => l_inst_set(i).ptip_id
5211: ,c_only_pls_subj_cobra_flag => l_inst_set(i).only_pls_subj_cobra_flag
5212: );

Line 5317: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..

5313: l_rows_found := true;
5314: --
5315: -- 9999 FONM : how is this cache rebuilt.
5316: <>
5317: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
5318: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
5319: if ben_manage_life_events.g_cache_person_prtn(l_count).pl_id =
5320: l_inst_set(i).pl_id then
5321: --

Line 5318: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop

5314: --
5315: -- 9999 FONM : how is this cache rebuilt.
5316: <>
5317: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
5318: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
5319: if ben_manage_life_events.g_cache_person_prtn(l_count).pl_id =
5320: l_inst_set(i).pl_id then
5321: --
5322: -- Apply the date logic to the life event occurred date.

Line 5319: if ben_manage_life_events.g_cache_person_prtn(l_count).pl_id =

5315: -- 9999 FONM : how is this cache rebuilt.
5316: <>
5317: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
5318: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
5319: if ben_manage_life_events.g_cache_person_prtn(l_count).pl_id =
5320: l_inst_set(i).pl_id then
5321: --
5322: -- Apply the date logic to the life event occurred date.
5323: --

Line 5328: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

5324: ben_determine_date.main
5325: (p_date_cd => l_inst_set(i).enrl_det_dt_cd,
5326: p_effective_date => p_effective_date,
5327: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5328: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
5329: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
5330: p_returned_date => l_date_to_use);
5331: --
5332:

Line 5329: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

5325: (p_date_cd => l_inst_set(i).enrl_det_dt_cd,
5326: p_effective_date => p_effective_date,
5327: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5328: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
5329: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
5330: p_returned_date => l_date_to_use);
5331: --
5332:
5333: if (l_date_to_use

Line 5334: between ben_manage_life_events.g_cache_person_prtn(l_count).enrt_cvg_strt_dt

5330: p_returned_date => l_date_to_use);
5331: --
5332:
5333: if (l_date_to_use
5334: between ben_manage_life_events.g_cache_person_prtn(l_count).enrt_cvg_strt_dt
5335: and ben_manage_life_events.g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
5336: l_found_plan := true;
5337: --
5338: if l_inst_set(i).excld_flag = 'N'then

Line 5335: and ben_manage_life_events.g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then

5331: --
5332:
5333: if (l_date_to_use
5334: between ben_manage_life_events.g_cache_person_prtn(l_count).enrt_cvg_strt_dt
5335: and ben_manage_life_events.g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
5336: l_found_plan := true;
5337: --
5338: if l_inst_set(i).excld_flag = 'N'then
5339: --

Line 5442: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..

5438: l_rows_found := true;
5439: --
5440: -- 9999 FONM : how is this cache rebuilt.
5441: <>
5442: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
5443: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
5444: if ben_manage_life_events.
5445: g_cache_person_prtn(l_count).oipl_id =
5446: l_inst_set(i).oipl_id then

Line 5443: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop

5439: --
5440: -- 9999 FONM : how is this cache rebuilt.
5441: <>
5442: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
5443: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
5444: if ben_manage_life_events.
5445: g_cache_person_prtn(l_count).oipl_id =
5446: l_inst_set(i).oipl_id then
5447: --

Line 5444: if ben_manage_life_events.

5440: -- 9999 FONM : how is this cache rebuilt.
5441: <>
5442: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
5443: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
5444: if ben_manage_life_events.
5445: g_cache_person_prtn(l_count).oipl_id =
5446: l_inst_set(i).oipl_id then
5447: --
5448: -- Apply the date logic to the life event occurred date.

Line 5454: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

5450: ben_determine_date.main
5451: (p_date_cd => l_inst_set(i).enrl_det_dt_cd,
5452: p_effective_date => p_effective_date,
5453: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5454: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
5455: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
5456: p_returned_date => l_date_to_use);
5457: --
5458: if (l_date_to_use

Line 5455: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

5451: (p_date_cd => l_inst_set(i).enrl_det_dt_cd,
5452: p_effective_date => p_effective_date,
5453: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5454: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
5455: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
5456: p_returned_date => l_date_to_use);
5457: --
5458: if (l_date_to_use
5459: between ben_manage_life_events.g_cache_person_prtn(l_count).enrt_cvg_strt_dt

Line 5459: between ben_manage_life_events.g_cache_person_prtn(l_count).enrt_cvg_strt_dt

5455: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
5456: p_returned_date => l_date_to_use);
5457: --
5458: if (l_date_to_use
5459: between ben_manage_life_events.g_cache_person_prtn(l_count).enrt_cvg_strt_dt
5460: and ben_manage_life_events.g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
5461: --
5462: l_found_oipl := true;
5463: --

Line 5460: and ben_manage_life_events.g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then

5456: p_returned_date => l_date_to_use);
5457: --
5458: if (l_date_to_use
5459: between ben_manage_life_events.g_cache_person_prtn(l_count).enrt_cvg_strt_dt
5460: and ben_manage_life_events.g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
5461: --
5462: l_found_oipl := true;
5463: --
5464: if l_inst_set(i).excld_flag = 'N'then

Line 5589: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..

5585: l_rows_found := true;
5586: --
5587: hr_utility.set_location('Getting results',10);
5588: <>
5589: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
5590: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
5591: if ben_manage_life_events.
5592: g_cache_person_prtn(l_count).ptip_id =
5593: l_inst_set(i).ptip_id then

Line 5590: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop

5586: --
5587: hr_utility.set_location('Getting results',10);
5588: <>
5589: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
5590: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
5591: if ben_manage_life_events.
5592: g_cache_person_prtn(l_count).ptip_id =
5593: l_inst_set(i).ptip_id then
5594: --

Line 5591: if ben_manage_life_events.

5587: hr_utility.set_location('Getting results',10);
5588: <>
5589: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
5590: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
5591: if ben_manage_life_events.
5592: g_cache_person_prtn(l_count).ptip_id =
5593: l_inst_set(i).ptip_id then
5594: --
5595: -- Apply the date logic to the life event occurred date.

Line 5601: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

5597: ben_determine_date.main
5598: (p_date_cd => l_inst_set(i).enrl_det_dt_cd,
5599: p_effective_date => p_effective_date,
5600: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5601: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
5602: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
5603: p_returned_date => l_date_to_use);
5604: --
5605: -- If only check plans that are subject to COBRA.

Line 5602: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

5598: (p_date_cd => l_inst_set(i).enrl_det_dt_cd,
5599: p_effective_date => p_effective_date,
5600: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5601: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
5602: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
5603: p_returned_date => l_date_to_use);
5604: --
5605: -- If only check plans that are subject to COBRA.
5606: --

Line 5613: open c1(ben_manage_life_events.g_cache_person_prtn(l_count).pl_id);

5609: hr_utility.set_location('Getting cobra plans',10);
5610: --
5611: if l_inst_set(i).only_pls_subj_cobra_flag = 'Y' then
5612: --
5613: open c1(ben_manage_life_events.g_cache_person_prtn(l_count).pl_id);
5614: --
5615: fetch c1 into l_dummy;
5616: --
5617: if c1%notfound then

Line 5633: between ben_manage_life_events.

5629: --
5630: hr_utility.set_location('Cobra plans found',10);
5631: --
5632: if (l_date_to_use
5633: between ben_manage_life_events.
5634: g_cache_person_prtn(l_count).enrt_cvg_strt_dt
5635: and ben_manage_life_events.
5636: g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
5637: --

Line 5635: and ben_manage_life_events.

5631: --
5632: if (l_date_to_use
5633: between ben_manage_life_events.
5634: g_cache_person_prtn(l_count).enrt_cvg_strt_dt
5635: and ben_manage_life_events.
5636: g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
5637: --
5638: l_found_ptip := true;
5639: --

Line 5760: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

5756: ben_determine_date.main
5757: (p_date_cd => l_inst_set(i).enrl_det_dt_cd,
5758: p_effective_date => p_effective_date,
5759: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5760: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
5761: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
5762: p_returned_date => l_date_to_use);
5763: --
5764: open c1(l_inst_set(i).plip_id);

Line 5761: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

5757: (p_date_cd => l_inst_set(i).enrl_det_dt_cd,
5758: p_effective_date => p_effective_date,
5759: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5760: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
5761: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
5762: p_returned_date => l_date_to_use);
5763: --
5764: open c1(l_inst_set(i).plip_id);
5765: fetch c1 into l_dummy;

Line 5860: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..

5856: --
5857: l_rows_found := true;
5858: --
5859: <>
5860: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
5861: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
5862: if ben_manage_life_events.g_cache_person_prtn(l_count).pgm_id =
5863: l_inst_set(i).pgm_id then
5864: l_found_pgm := true;

Line 5861: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop

5857: l_rows_found := true;
5858: --
5859: <>
5860: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
5861: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
5862: if ben_manage_life_events.g_cache_person_prtn(l_count).pgm_id =
5863: l_inst_set(i).pgm_id then
5864: l_found_pgm := true;
5865: --

Line 5862: if ben_manage_life_events.g_cache_person_prtn(l_count).pgm_id =

5858: --
5859: <>
5860: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
5861: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
5862: if ben_manage_life_events.g_cache_person_prtn(l_count).pgm_id =
5863: l_inst_set(i).pgm_id then
5864: l_found_pgm := true;
5865: --
5866: -- Apply the date logic to the life event occurred date.

Line 5872: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

5868: ben_determine_date.main
5869: (p_date_cd => l_inst_set(i).enrl_det_dt_cd,
5870: p_effective_date => p_effective_date,
5871: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5872: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
5873: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
5874: p_returned_date => l_date_to_use);
5875: --
5876: if (l_date_to_use

Line 5873: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

5869: (p_date_cd => l_inst_set(i).enrl_det_dt_cd,
5870: p_effective_date => p_effective_date,
5871: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
5872: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
5873: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
5874: p_returned_date => l_date_to_use);
5875: --
5876: if (l_date_to_use
5877: between ben_manage_life_events.g_cache_person_prtn(l_count).enrt_cvg_strt_dt

Line 5877: between ben_manage_life_events.g_cache_person_prtn(l_count).enrt_cvg_strt_dt

5873: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
5874: p_returned_date => l_date_to_use);
5875: --
5876: if (l_date_to_use
5877: between ben_manage_life_events.g_cache_person_prtn(l_count).enrt_cvg_strt_dt
5878: and ben_manage_life_events.g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
5879: --
5880: if l_inst_set(i).excld_flag = 'N'then
5881: --

Line 5878: and ben_manage_life_events.g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then

5874: p_returned_date => l_date_to_use);
5875: --
5876: if (l_date_to_use
5877: between ben_manage_life_events.g_cache_person_prtn(l_count).enrt_cvg_strt_dt
5878: and ben_manage_life_events.g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
5879: --
5880: if l_inst_set(i).excld_flag = 'N'then
5881: --
5882: l_ok := true;

Line 6047: ,c_eff_date => nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

6043: --
6044: open c1
6045: (c_ptip_id => l_inst_set(i).ptip_id
6046: ,c_bgp_id => p_business_group_id
6047: ,c_eff_date => nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
6048: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
6049: nvl(p_lf_evt_ocrd_dt,p_effective_date)))
6050: ,c_dpnt_person_id => p_person_id
6051: );

Line 6048: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

6044: open c1
6045: (c_ptip_id => l_inst_set(i).ptip_id
6046: ,c_bgp_id => p_business_group_id
6047: ,c_eff_date => nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
6048: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
6049: nvl(p_lf_evt_ocrd_dt,p_effective_date)))
6050: ,c_dpnt_person_id => p_person_id
6051: );
6052: fetch c1 into l_dummy;

Line 6281: ,nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

6277: --
6278: open c1(p_person_id
6279: ,l_inst_set(i).competence_id
6280: ,l_inst_set(i).rating_level_id
6281: ,nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
6282: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
6283: nvl(p_lf_evt_ocrd_dt, p_effective_date))) );
6284: fetch c1 into l_dummy;
6285: if c1%found then

Line 6282: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

6278: open c1(p_person_id
6279: ,l_inst_set(i).competence_id
6280: ,l_inst_set(i).rating_level_id
6281: ,nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
6282: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
6283: nvl(p_lf_evt_ocrd_dt, p_effective_date))) );
6284: fetch c1 into l_dummy;
6285: if c1%found then
6286: --

Line 6375: ,nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

6371: --
6372: open c1(p_person_id
6373: ,l_inst_set(i).qualification_type_id
6374: ,l_inst_set(i).title
6375: ,nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
6376: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
6377: nvl(p_lf_evt_ocrd_dt, p_effective_date))));
6378: fetch c1 into l_dummy;
6379: if c1%found then

Line 6376: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

6372: open c1(p_person_id
6373: ,l_inst_set(i).qualification_type_id
6374: ,l_inst_set(i).title
6375: ,nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
6376: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
6377: nvl(p_lf_evt_ocrd_dt, p_effective_date))));
6378: fetch c1 into l_dummy;
6379: if c1%found then
6380: --

Line 6607: ,nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

6603: --
6604: if l_inst_count > 0 then
6605: open c1(p_grade_id
6606: ,p_business_group_id
6607: ,nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
6608: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
6609: nvl(p_lf_evt_ocrd_dt, p_effective_date)))
6610: ,p_pay_basis_id);
6611: fetch c1 into l_max_val, l_min_val;

Line 6608: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

6604: if l_inst_count > 0 then
6605: open c1(p_grade_id
6606: ,p_business_group_id
6607: ,nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
6608: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
6609: nvl(p_lf_evt_ocrd_dt, p_effective_date)))
6610: ,p_pay_basis_id);
6611: fetch c1 into l_max_val, l_min_val;
6612: close c1;

Line 6616: ,nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

6612: close c1;
6613: /* Bug 4031314
6614: open c2(p_assignment_id
6615: ,p_business_group_id
6616: ,nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
6617: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
6618: nvl(p_lf_evt_ocrd_dt, p_effective_date)))
6619: ,p_pay_basis_id) ;
6620: fetch c2 into l_person_sal;

Line 6617: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

6613: /* Bug 4031314
6614: open c2(p_assignment_id
6615: ,p_business_group_id
6616: ,nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
6617: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
6618: nvl(p_lf_evt_ocrd_dt, p_effective_date)))
6619: ,p_pay_basis_id) ;
6620: fetch c2 into l_person_sal;
6621: close c2;

Line 6625: p_lf_evt_ocrd_dt => nvl( ben_manage_life_events.g_fonm_rt_strt_dt,

6621: close c2;
6622: */
6623: open c_salary ( p_assignment_id => p_assignment_id,
6624: p_business_group_id => p_business_group_id,
6625: p_lf_evt_ocrd_dt => nvl( ben_manage_life_events.g_fonm_rt_strt_dt,
6626: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
6627: nvl(p_lf_evt_ocrd_dt, p_effective_date
6628: )
6629: )

Line 6626: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

6622: */
6623: open c_salary ( p_assignment_id => p_assignment_id,
6624: p_business_group_id => p_business_group_id,
6625: p_lf_evt_ocrd_dt => nvl( ben_manage_life_events.g_fonm_rt_strt_dt,
6626: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
6627: nvl(p_lf_evt_ocrd_dt, p_effective_date
6628: )
6629: )
6630: )

Line 6797: p_effective_date => NVL (ben_manage_life_events.g_fonm_rt_strt_dt,

6793: then
6794: --
6795: OPEN c2_without_events (
6796: p_person_id => p_person_id,
6797: p_effective_date => NVL (ben_manage_life_events.g_fonm_rt_strt_dt,
6798: NVL (ben_manage_life_events.g_fonm_cvg_strt_dt,
6799: NVL (p_lf_evt_ocrd_dt,
6800: p_effective_date
6801: )

Line 6798: NVL (ben_manage_life_events.g_fonm_cvg_strt_dt,

6794: --
6795: OPEN c2_without_events (
6796: p_person_id => p_person_id,
6797: p_effective_date => NVL (ben_manage_life_events.g_fonm_rt_strt_dt,
6798: NVL (ben_manage_life_events.g_fonm_cvg_strt_dt,
6799: NVL (p_lf_evt_ocrd_dt,
6800: p_effective_date
6801: )
6802: )

Line 6840: p_lf_evt_ocrd_dt => NVL (ben_manage_life_events.g_fonm_rt_strt_dt,

6836: OPEN c1 (p_person_id => p_person_id,
6837: p_event_type => l_inst_set (i).event_type,
6838: p_business_group_id => p_business_group_id,
6839: p_assignment_id => p_assignment_id,
6840: p_lf_evt_ocrd_dt => NVL (ben_manage_life_events.g_fonm_rt_strt_dt,
6841: NVL (ben_manage_life_events.g_fonm_cvg_strt_dt,
6842: NVL (p_lf_evt_ocrd_dt,
6843: p_effective_date
6844: )

Line 6841: NVL (ben_manage_life_events.g_fonm_cvg_strt_dt,

6837: p_event_type => l_inst_set (i).event_type,
6838: p_business_group_id => p_business_group_id,
6839: p_assignment_id => p_assignment_id,
6840: p_lf_evt_ocrd_dt => NVL (ben_manage_life_events.g_fonm_rt_strt_dt,
6841: NVL (ben_manage_life_events.g_fonm_cvg_strt_dt,
6842: NVL (p_lf_evt_ocrd_dt,
6843: p_effective_date
6844: )
6845: )

Line 7233: if ben_manage_life_events.fonm = 'Y' then

7229: --
7230: end if;
7231: --
7232: -- FONM
7233: if ben_manage_life_events.fonm = 'Y' then
7234: --
7235: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
7236: ben_manage_life_events.g_fonm_cvg_strt_dt);
7237: --

Line 7235: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

7231: --
7232: -- FONM
7233: if ben_manage_life_events.fonm = 'Y' then
7234: --
7235: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
7236: ben_manage_life_events.g_fonm_cvg_strt_dt);
7237: --
7238: end if;
7239: --

Line 7236: ben_manage_life_events.g_fonm_cvg_strt_dt);

7232: -- FONM
7233: if ben_manage_life_events.fonm = 'Y' then
7234: --
7235: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
7236: ben_manage_life_events.g_fonm_cvg_strt_dt);
7237: --
7238: end if;
7239: --
7240: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);

Line 8108: p_effective_date => nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

8104: p_person_id => p_person_id,
8105: p_business_group_id => p_business_group_id,
8106: -- FONM : as lf_evt_ocrd_dt is not used, it's fine to overload the
8107: -- p_effective_date.
8108: p_effective_date => nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
8109: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
8110: nvl(p_lf_evt_ocrd_dt, p_effective_date))),
8111: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
8112: p_pgm_id => l_epe.pgm_id,

Line 8109: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

8105: p_business_group_id => p_business_group_id,
8106: -- FONM : as lf_evt_ocrd_dt is not used, it's fine to overload the
8107: -- p_effective_date.
8108: p_effective_date => nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
8109: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
8110: nvl(p_lf_evt_ocrd_dt, p_effective_date))),
8111: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
8112: p_pgm_id => l_epe.pgm_id,
8113: p_pl_id => l_epe.pl_id,

Line 8208: p_effective_date => nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

8204: p_person_id => p_person_id,
8205: p_business_group_id => p_business_group_id,
8206: -- FONM : as lf_evt_ocrd_dt is not used, it's fine to overload the
8207: -- p_effective_date.
8208: p_effective_date => nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
8209: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
8210: nvl(p_lf_evt_ocrd_dt, p_effective_date))),
8211: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
8212: p_pgm_id => l_epe.pgm_id,

Line 8209: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

8205: p_business_group_id => p_business_group_id,
8206: -- FONM : as lf_evt_ocrd_dt is not used, it's fine to overload the
8207: -- p_effective_date.
8208: p_effective_date => nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
8209: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
8210: nvl(p_lf_evt_ocrd_dt, p_effective_date))),
8211: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
8212: p_pgm_id => l_epe.pgm_id,
8213: p_pl_id => l_epe.pl_id,

Line 8452: p_effective_date => nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

8448: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8449: p_business_group_id => p_business_group_id,
8450: -- FONM : as lf_evt_ocrd_dt is not used, it's fine to overload the
8451: -- p_effective_date.
8452: p_effective_date => nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
8453: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
8454: nvl(p_lf_evt_ocrd_dt, p_effective_date))),
8455: p_person_id => p_person_id,
8456: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt );

Line 8453: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

8449: p_business_group_id => p_business_group_id,
8450: -- FONM : as lf_evt_ocrd_dt is not used, it's fine to overload the
8451: -- p_effective_date.
8452: p_effective_date => nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
8453: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
8454: nvl(p_lf_evt_ocrd_dt, p_effective_date))),
8455: p_person_id => p_person_id,
8456: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt );
8457: end if;