DBA Data[Home] [Help]

APPS.PAY_ELEMENT_SETS_PKG dependencies on PAY_ELE_CLASSIFICATION_RULES

Line 122: from pay_ele_classification_rules ecr,

118: from pay_element_classifications ecl
119: where ecl.classification_id = p_classification_id
120: and exists
121: (select null
122: from pay_ele_classification_rules ecr,
123: pay_element_classifications ecl2
124: where ecr.element_set_id = p_element_set_id
125: and ecl2.classification_id = ecr.classification_id
126: and ecl2.costing_debit_or_credit <>

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 328: delete from pay_ele_classification_rules

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;
330: --
331: end delete_element_set_cascade;
332: --