APPS.PAY_ELEMENT_SETS_PKG dependencies on PAY_ELEMENT_TYPE_RULES

Line 107: from pay_element_type_rules etr,

103: from pay_element_classifications ecl
104: where ecl.classification_id = p_classification_id
105: and exists
106: (select null
107: from pay_element_type_rules etr,
108: pay_element_types_f et,
109: pay_element_classifications ecl2
110: where etr.element_set_id = p_element_set_id
111: and et.element_type_id = etr.element_type_id

Line 315: -- Removes PAY_ELEMENT_TYPE_RULES and PAY_ELE_CLASSIFICATION_RULES. --

311: -- Removes all children of an element set. --
312: -- Arguments --
313: -- See below. --
314: -- Notes --
315: -- Removes PAY_ELEMENT_TYPE_RULES and PAY_ELE_CLASSIFICATION_RULES. --
316: -----------------------------------------------------------------------------
317: --
318: procedure delete_element_set_cascade
319: (

Line 325: delete from pay_element_type_rules

321: ) is
322: --
323: begin
324: --
325: delete from pay_element_type_rules
326: where element_set_id = p_element_set_id;
327: --
328: delete from pay_ele_classification_rules
329: where element_set_id = p_element_set_id;