164: -- Bug 3795968 Starts Here
165: OPEN csr_full_hr_installed;
166: FETCH csr_full_hr_installed INTO l_dummy;
167: IF csr_full_hr_installed%FOUND THEN
168: hrdyndbi.create_grade_spine_dict(p_rate_id => l_rate_id);
169: END IF;
170: CLOSE csr_full_hr_installed;
171: -- Bug 3795968 Ends Here
172: --
520: -- Bug 3795968 Starts Here
521: OPEN csr_full_hr_installed;
522: FETCH csr_full_hr_installed INTO l_dummy;
523: IF csr_full_hr_installed%FOUND THEN
524: hrdyndbi.delete_grade_spine_dict(p_rate_id => p_rate_id);
525: hrdyndbi.create_grade_spine_dict(p_rate_id => p_rate_id);
526: END IF;
527: CLOSE csr_full_hr_installed;
528: -- Bug 3795968 Ends Here
521: OPEN csr_full_hr_installed;
522: FETCH csr_full_hr_installed INTO l_dummy;
523: IF csr_full_hr_installed%FOUND THEN
524: hrdyndbi.delete_grade_spine_dict(p_rate_id => p_rate_id);
525: hrdyndbi.create_grade_spine_dict(p_rate_id => p_rate_id);
526: END IF;
527: CLOSE csr_full_hr_installed;
528: -- Bug 3795968 Ends Here
529: --
748: -- Bug 3795968 Starts Here
749: OPEN csr_full_hr_installed;
750: FETCH csr_full_hr_installed INTO l_dummy;
751: IF csr_full_hr_installed%FOUND THEN
752: hrdyndbi.delete_grade_spine_dict(p_rate_id => p_rate_id);
753: END IF;
754: CLOSE csr_full_hr_installed;
755: -- Bug 3795968 Ends Here
756: --