DBA Data[Home] [Help]

APPS.BEN_PERSON_OBJECT dependencies on BEN_MANAGE_LIFE_EVENTS

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

1110: -- 3) Pass record to set_object routine.
1111: --
1112: -- FONM
1113: --
1114: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
1115: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
1116: p_effective_date)
1117: );
1118: open c1;

Line 1115: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

1111: --
1112: -- FONM
1113: --
1114: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
1115: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
1116: p_effective_date)
1117: );
1118: open c1;
1119: --

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

2210: ben_env_object.get(p_rec => l_env);
2211: --
2212: -- FONM
2213: --
2214: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2215: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2216: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2217: );
2218: --

Line 2215: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

2211: --
2212: -- FONM
2213: --
2214: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2215: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2216: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2217: );
2218: --
2219: set_per_object(p_person_id => p_person_id,

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

2289: ben_env_object.get(p_rec => l_env);
2290: --
2291: -- FONM
2292: --
2293: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2294: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2295: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2296: );
2297: --

Line 2294: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

2290: --
2291: -- FONM
2292: --
2293: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2294: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2295: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2296: );
2297: --
2298: set_bnb_object(p_bnfts_bal_id => p_bnfts_bal_id,

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

2428: ben_env_object.get(p_rec => l_env);
2429: --
2430: -- FONM
2431: --
2432: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2433: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2434: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2435: );
2436: --

Line 2433: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

2429: --
2430: -- FONM
2431: --
2432: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2433: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2434: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2435: );
2436: --
2437: set_ass_object(p_person_id => p_person_id,

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

2506: ben_env_object.get(p_rec => l_env);
2507: --
2508: -- FONM
2509: --
2510: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2511: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2512: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2513: );
2514: --

Line 2511: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

2507: --
2508: -- FONM
2509: --
2510: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2511: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2512: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2513: );
2514: --
2515: set_benass_object(p_person_id => p_person_id,

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

2705: ben_env_object.get(p_rec => l_env);
2706: --
2707: -- FONM
2708: --
2709: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2710: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2711: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2712: );
2713: --

Line 2710: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

2706: --
2707: -- FONM
2708: --
2709: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2710: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2711: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2712: );
2713: --
2714: set_pil_object(p_person_id => p_person_id,

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

2783: ben_env_object.get(p_rec => l_env);
2784: --
2785: -- FONM
2786: --
2787: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2788: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2789: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2790: );
2791: --

Line 2788: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

2784: --
2785: -- FONM
2786: --
2787: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2788: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2789: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2790: );
2791: --
2792: set_pad_object(p_person_id => p_person_id,

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

2859: ben_env_object.get(p_rec => l_env);
2860: --
2861: -- FONM
2862: --
2863: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2864: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2865: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2866: );
2867: --

Line 2864: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

2860: --
2861: -- FONM
2862: --
2863: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2864: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2865: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2866: );
2867: --
2868: set_pps_object(p_person_id => p_person_id,

Line 2899: nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

2895: -- hr_utility.set_location('Entering '||l_proc,10);
2896: --
2897: if g_cache_last_bal_rec.person_id = p_person_id and
2898: g_cache_last_bal_rec.bnfts_bal_id = p_bnfts_bal_id and
2899: nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2900: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt, p_effective_date))
2901: between g_cache_last_bal_rec.effective_start_date
2902: and g_cache_last_bal_rec.effective_end_date then
2903: --

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

2896: --
2897: if g_cache_last_bal_rec.person_id = p_person_id and
2898: g_cache_last_bal_rec.bnfts_bal_id = p_bnfts_bal_id and
2899: nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2900: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt, p_effective_date))
2901: between g_cache_last_bal_rec.effective_start_date
2902: and g_cache_last_bal_rec.effective_end_date then
2903: --
2904: p_rec := g_cache_last_bal_rec;

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

2937: -- FONM
2938: --
2939: ben_env_object.get(p_rec => l_env);
2940: --
2941: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2942: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2943: p_effective_date)
2944: );
2945: --

Line 2942: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

2938: --
2939: ben_env_object.get(p_rec => l_env);
2940: --
2941: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2942: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2943: p_effective_date)
2944: );
2945: --
2946: hr_utility.set_location('Before get_bal_per_object '||l_proc,10);

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

2961: ben_env_object.get(p_rec => l_env);
2962: --
2963: -- FONM
2964: --
2965: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2966: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2967: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2968: );
2969: --

Line 2966: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

2962: --
2963: -- FONM
2964: --
2965: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2966: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2967: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
2968: );
2969: --
2970: set_bal_object(p_person_id => p_person_id,

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

3069: ben_env_object.get(p_rec => l_env);
3070: --
3071: -- FONM
3072: --
3073: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3074: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3075: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3076: );
3077: --

Line 3074: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

3070: --
3071: -- FONM
3072: --
3073: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3074: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3075: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3076: );
3077: --
3078: set_con_object(p_person_id => p_person_id,

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

3174: ben_env_object.get(p_rec => l_env);
3175: --
3176: -- FONM
3177: --
3178: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3179: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3180: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3181: );
3182: --

Line 3179: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

3175: --
3176: -- FONM
3177: --
3178: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3179: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3180: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3181: );
3182: --
3183: set_appass_object(p_person_id => p_person_id,

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

3279: ben_env_object.get(p_rec => l_env);
3280: --
3281: -- FONM
3282: --
3283: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3284: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3285: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3286: );
3287: --

Line 3284: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

3280: --
3281: -- FONM
3282: --
3283: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3284: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3285: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3286: );
3287: --
3288: set_allass_object(p_person_id => p_person_id,

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

3380: ben_env_object.get(p_rec => l_env);
3381: --
3382: -- FONM
3383: --
3384: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3385: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3386: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3387: );
3388: --

Line 3385: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

3381: --
3382: -- FONM
3383: --
3384: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3385: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3386: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3387: );
3388: --
3389: set_typ_object(p_person_id => p_person_id,

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

3544: ben_env_object.get(p_rec => l_env);
3545: --
3546: -- FONM
3547: --
3548: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3549: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3550: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3551: );
3552: --

Line 3549: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

3545: --
3546: -- FONM
3547: --
3548: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3549: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3550: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3551: );
3552: --
3553: set_per_dates_object(p_person_id => p_person_id,

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

3621: ben_env_object.get(p_rec => l_env);
3622: --
3623: -- FONM
3624: --
3625: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3626: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3627: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3628: );
3629: --

Line 3626: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

3622: --
3623: -- FONM
3624: --
3625: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3626: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3627: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
3628: );
3629: --
3630: set_per_fte_object(p_assignment_id => p_assignment_id,