DBA Data[Home] [Help]

APPS.HR_LEGISLATION_ELEMENTS dependencies on PAY_ELEMENT_TYPE_RULES

Line 3099: delete from pay_element_type_rules

3095: IF p_phase = 1 THEN
3096: return;
3097: END IF;
3098:
3099: delete from pay_element_type_rules
3100: where element_set_id = l_new_surrogate_key;
3101:
3102: delete from pay_ele_classification_rules
3103: where element_set_id = l_new_surrogate_key;

Line 3171: insert into pay_element_type_rules

3167: from pay_element_types_f
3168: where element_type_id = ele_types.element_type_id;
3169:
3170: BEGIN
3171: insert into pay_element_type_rules
3172: (element_type_id
3173: ,element_set_id
3174: ,include_or_exclude
3175: ,last_update_date

Line 3191: hr_utility.trace('ins pay_element_type_rules');

3187: ,ele_types.created_by
3188: ,ele_types.creation_date);
3189: EXCEPTION WHEN OTHERS THEN
3190: hr_legislation.hrrunprc_trace_on;
3191: hr_utility.trace('ins pay_element_type_rules');
3192: hr_utility.trace('element_type_id ' ||
3193: to_char(ele_types.element_Type_id));
3194: hr_utility.trace('element_set_id ' ||
3195: to_char(ele_types.element_Set_id));