APPS.PQH_PA_WHATIF_PROCESS dependencies on BEN_PER_IN_LER

Line 218: UPDATE ben_per_in_ler

214: l_proc := g_package || 'void_active_life_events';
215: hr_utility.set_location('Entering: ' || l_proc,10);
216: end if;
217:
218: UPDATE ben_per_in_ler
219: SET per_in_ler_stat_cd = 'VOIDD'
220: ,voidd_dt = p_effective_date
221: WHERE person_id = p_person_id
222: AND business_group_id = p_business_group_id

Line 2291: From ben_per_in_ler pil,

2287: CURSOR csr_ler IS
2288: Select pil.per_in_ler_id,
2289: ler.name name,
2290: ler.ler_id
2291: From ben_per_in_ler pil,
2292: ben_ler_f ler
2293: Where pil.person_id = p_person_id
2294: AND ler.ler_id = pil.ler_id
2295: AND p_effective_date BETWEEN ler.effective_start_date and ler.effective_end_date

Line 2946: From ben_per_in_ler pil,

2942: CURSOR csr_ler IS
2943: Select pil.per_in_ler_id,
2944: ler.name name,
2945: ler.ler_id
2946: From ben_per_in_ler pil,
2947: ben_ler_f ler
2948: Where pil.person_id = p_person_id
2949: AND ler.ler_id = pil.ler_id
2950: AND p_effective_date BETWEEN ler.effective_start_date and ler.effective_end_date