APPS.BEN_PERSON_OBJECT dependencies on BEN_MANAGE_LIFE_EVENTS

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

1141: -- 3) Pass record to set_object routine.
1142: --
1143: -- FONM
1144: --
1145: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
1146: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
1147: p_effective_date)
1148: );
1149: open c1;

Line 1146: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

1142: --
1143: -- FONM
1144: --
1145: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
1146: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
1147: p_effective_date)
1148: );
1149: open c1;
1150: --

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

2264: ben_env_object.get(p_rec => l_env);
2265: --
2266: -- FONM
2267: --
2268: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2269: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2270: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2271: );
2272: --

Line 2269: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

2265: --
2266: -- FONM
2267: --
2268: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2269: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2270: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2271: );
2272: --
2273: set_per_object(p_person_id => p_person_id,

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

2343: ben_env_object.get(p_rec => l_env);
2344: --
2345: -- FONM
2346: --
2347: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2348: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2349: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2350: );
2351: --

Line 2348: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

2344: --
2345: -- FONM
2346: --
2347: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2348: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2349: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2350: );
2351: --
2352: set_bnb_object(p_bnfts_bal_id => p_bnfts_bal_id,

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

2497: ben_env_object.get(p_rec => l_env);
2498: --
2499: -- FONM
2500: --
2501: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2502: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2503: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2504: );
2505: --

Line 2502: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

2498: --
2499: -- FONM
2500: --
2501: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2502: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2503: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2504: );
2505: --
2506: set_ass_object(p_person_id => p_person_id,

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

2577: ben_env_object.get(p_rec => l_env);
2578: --
2579: -- FONM
2580: --
2581: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2582: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2583: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2584: );
2585: --

Line 2582: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

2578: --
2579: -- FONM
2580: --
2581: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2582: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2583: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2584: );
2585: --
2586: set_ass_object(p_person_id => p_person_id,

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

2655: ben_env_object.get(p_rec => l_env);
2656: --
2657: -- FONM
2658: --
2659: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2660: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2661: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2662: );
2663: --

Line 2660: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

2656: --
2657: -- FONM
2658: --
2659: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2660: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2661: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2662: );
2663: --
2664: set_benass_object(p_person_id => p_person_id,

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

2855: ben_env_object.get(p_rec => l_env);
2856: --
2857: -- FONM
2858: --
2859: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2860: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2861: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2862: );
2863: --

Line 2860: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

2856: --
2857: -- FONM
2858: --
2859: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2860: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2861: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2862: );
2863: --
2864: set_pil_object(p_person_id => p_person_id,

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

2933: ben_env_object.get(p_rec => l_env);
2934: --
2935: -- FONM
2936: --
2937: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2938: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2939: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2940: );
2941: --

Line 2938: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

2934: --
2935: -- FONM
2936: --
2937: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2938: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2939: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2940: );
2941: --
2942: set_pad_object(p_person_id => p_person_id,

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

3009: ben_env_object.get(p_rec => l_env);
3010: --
3011: -- FONM
3012: --
3013: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3014: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3015: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3016: );
3017: --

Line 3014: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

3010: --
3011: -- FONM
3012: --
3013: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3014: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3015: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3016: );
3017: --
3018: set_pps_object(p_person_id => p_person_id,

Line 3049: nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

3045: -- hr_utility.set_location('Entering '||l_proc,10);
3046: --
3047: if g_cache_last_bal_rec.person_id = p_person_id and
3048: g_cache_last_bal_rec.bnfts_bal_id = p_bnfts_bal_id and
3049: nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3050: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt, p_effective_date))
3051: between g_cache_last_bal_rec.effective_start_date
3052: and g_cache_last_bal_rec.effective_end_date then
3053: --

Line 3050: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt, p_effective_date))

3046: --
3047: if g_cache_last_bal_rec.person_id = p_person_id and
3048: g_cache_last_bal_rec.bnfts_bal_id = p_bnfts_bal_id and
3049: nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3050: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt, p_effective_date))
3051: between g_cache_last_bal_rec.effective_start_date
3052: and g_cache_last_bal_rec.effective_end_date then
3053: --
3054: p_rec := g_cache_last_bal_rec;

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

3087: -- FONM
3088: --
3089: ben_env_object.get(p_rec => l_env);
3090: --
3091: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3092: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3093: p_effective_date)
3094: );
3095: --

Line 3092: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

3088: --
3089: ben_env_object.get(p_rec => l_env);
3090: --
3091: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3092: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3093: p_effective_date)
3094: );
3095: --
3096: hr_utility.set_location('Before get_bal_per_object '||l_proc,10);

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

3111: ben_env_object.get(p_rec => l_env);
3112: --
3113: -- FONM
3114: --
3115: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3116: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3117: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3118: );
3119: --

Line 3116: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

3112: --
3113: -- FONM
3114: --
3115: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3116: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3117: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3118: );
3119: --
3120: set_bal_object(p_person_id => p_person_id,

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

3219: ben_env_object.get(p_rec => l_env);
3220: --
3221: -- FONM
3222: --
3223: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3224: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3225: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3226: );
3227: --

Line 3224: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

3220: --
3221: -- FONM
3222: --
3223: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3224: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3225: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3226: );
3227: --
3228: set_con_object(p_person_id => p_person_id,

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

3324: ben_env_object.get(p_rec => l_env);
3325: --
3326: -- FONM
3327: --
3328: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3329: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3330: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3331: );
3332: --

Line 3329: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

3325: --
3326: -- FONM
3327: --
3328: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3329: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3330: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3331: );
3332: --
3333: set_appass_object(p_person_id => p_person_id,

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

3434: ben_env_object.get(p_rec => l_env);
3435: --
3436: -- FONM
3437: --
3438: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3439: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3440: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3441: );
3442: --

Line 3439: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

3435: --
3436: -- FONM
3437: --
3438: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3439: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3440: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3441: );
3442: --
3443: set_allass_object(p_person_id => p_person_id,

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

3535: ben_env_object.get(p_rec => l_env);
3536: --
3537: -- FONM
3538: --
3539: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3540: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3541: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3542: );
3543: --

Line 3540: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

3536: --
3537: -- FONM
3538: --
3539: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3540: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3541: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3542: );
3543: --
3544: set_typ_object(p_person_id => p_person_id,

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

3699: ben_env_object.get(p_rec => l_env);
3700: --
3701: -- FONM
3702: --
3703: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3704: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3705: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3706: );
3707: --

Line 3704: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

3700: --
3701: -- FONM
3702: --
3703: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3704: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3705: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3706: );
3707: --
3708: set_per_dates_object(p_person_id => p_person_id,

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

3776: ben_env_object.get(p_rec => l_env);
3777: --
3778: -- FONM
3779: --
3780: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3781: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3782: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3783: );
3784: --

Line 3781: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

3777: --
3778: -- FONM
3779: --
3780: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3781: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3782: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3783: );
3784: --
3785: set_per_fte_object(p_assignment_id => p_assignment_id,

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

3996: ben_env_object.get(p_rec => l_env);
3997: --
3998: -- FONM
3999: --
4000: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
4001: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
4002: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
4003: );
4004: --

Line 4001: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

3997: --
3998: -- FONM
3999: --
4000: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
4001: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
4002: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
4003: );
4004: --
4005: hr_utility.set_location('Entering '||l_proc,678);