67:
68: --
69: CURSOR c_next_val
70: IS
71: SELECT ben_icd_chc_rates_s.NEXTVAL
72: FROM DUAL;
73:
74: --
75: l_next_val NUMBER;
116:
117: CLOSE c_abr_info;
118:
119: --
120: INSERT INTO ben_icd_chc_rates
121: (icd_chc_rate_id, person_id, business_group_id,
122: assignment_id,
123: effective_date,
124: acty_base_rt_id,
410: --
411: ELSIF ben_icm_life_events.g_cache_pep_object (cache11).p_newly_inelig
412: THEN
413: --
414: DELETE FROM ben_icd_chc_rates
415: WHERE person_id = p_person_id
416: AND pl_id =
417: ben_icm_life_events.g_cache_pep_object
418: (cache11).pl_id;
593: THEN
594: hr_utility.set_location ('Deleting ICD Rates', 321);
595: END IF;
596:
597: DELETE FROM ben_icd_chc_rates
598: WHERE person_id = p_person_id
599: AND opt_id =
600: ben_icm_life_events.g_cache_epo_object
601: (cache11).opt_id;
1904: hr_utility.set_location ('Entering ' || l_proc, 10);
1905: END IF;
1906:
1907: --
1908: DELETE FROM ben_icd_chc_rates
1909: WHERE person_id = p_person_id;
1910: --
1911: COMMIT;
1912: --