214: -- Checks to see if the element set is being used. --
215: -- Arguments --
216: -- See below. --
217: -- Notes --
218: -- Checks PAY_RESTRICTION_VALUES, PAY_ELEMENT_LINKS_F and --
219: -- PAY_PAYROLL_ACTIONS. --
220: -----------------------------------------------------------------------------
221: --
222: procedure chk_delete_element_set
236: where pa.element_set_id = p_element_set_id;
237: --
238: cursor csr_restriction_values is
239: select fnd_number.canonical_to_number(rv.value)
240: from pay_restriction_values rv
241: where rv.restriction_code = 'ELEMENT_SET'
242: and rv.value = to_char(p_element_set_id);
243: --
244: cursor csr_element_set_usages is