DBA Data[Home] [Help]

APPS.PAY_ELEMENT_SETS_PKG dependencies on PAY_RESTRICTION_VALUES

Line 218: -- Checks PAY_RESTRICTION_VALUES, PAY_ELEMENT_LINKS_F and --

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

Line 240: from pay_restriction_values rv

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