718: -- ---------------------------------------------------------------------------
719: --
720: -- Description
721: -- This procedure is used to check that there are no values in
722: -- per_comp_element_outcomes.
723: --
724: -- Pre Conditions
725: -- None.
726: --
748: l_exists varchar2(1);
749: --
750: cursor csr_outcome is
751: select 'x'
752: FROM per_comp_element_outcomes
753: WHERE outcome_id = p_outcome_id;
754: --
755: Begin
756: --
755: Begin
756: --
757: hr_utility.set_location('Entering:'||l_proc, 10);
758: --
759: -- Check there are no values in per_comp_element_outcomes
760: --
761: open csr_outcome;
762: --
763: fetch csr_outcome into l_exists;