[Home] [Help]
354: defined plsql tuning.
355: 30-Jan-06 mhoyes 115.117 Bug#4968123 - moved out locall defined procs
356: to ben_determine_eligibility3.
357: 30-Jan-06 mhoyes 115.118 Bug#4968123 - moved out cursors
358: to ben_determine_eligibility4.
359: 28-Jun-06 swjain 115.119 Bug 5331889 Added person_id param in call to
360: benutils.formula in procedure get_start_end_dates
361: 24-Jul-06 kmahendr 115.120 Bug#5404392-added ben_newly_ineligible call
362: in the case of first time ineligible.
1792: if g_debug then
1793: hr_utility.set_location('fetch c_prvoptelch ben_determine_eligibility2.check_prev_elig', 10);
1794: end if;
1795: --
1796: ben_determine_eligibility4.prev_opt_elig_check
1797: (p_person_id => p_person_id
1798: ,p_effective_date => l_effective_dt
1799: ,p_pl_id => l_envpl_id
1800: ,p_opt_id => l_oipl_rec.opt_id
4271: hr_utility.set_location('l effective date'|| l_effective_dt,11);
4272: hr_utility.set_location('lf evt ocrd date'|| p_lf_evt_ocrd_dt,11);
4273: end if;
4274: --
4275: ben_determine_eligibility4.prev_elig_check
4276: (p_person_id => p_person_id
4277: ,p_pgm_id => nvl(p_pgm_id,nvl(l_envpgm_id,-1))
4278: ,p_pl_id => nvl(p_pl_id,-1)
4279: ,p_ptip_id => nvl(p_ptip_id,-1)