DBA Data[Home] [Help]

APPS.HR_LEGISLATION_ELEMENTS dependencies on PAY_ELEMENT_TYPE_RULES

Line 3067: delete from pay_element_type_rules

3063: IF p_phase = 1 THEN
3064: return;
3065: END IF;
3066:
3067: delete from pay_element_type_rules
3068: where element_set_id = l_new_surrogate_key;
3069:
3070: delete from pay_ele_classification_rules
3071: where element_set_id = l_new_surrogate_key;

Line 3139: insert into pay_element_type_rules

3135: from pay_element_types_f
3136: where element_type_id = ele_types.element_type_id;
3137:
3138: BEGIN
3139: insert into pay_element_type_rules
3140: (element_type_id
3141: ,element_set_id
3142: ,include_or_exclude
3143: ,last_update_date

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

3155: ,ele_types.created_by
3156: ,ele_types.creation_date);
3157: EXCEPTION WHEN OTHERS THEN
3158: hr_legislation.hrrunprc_trace_on;
3159: hr_utility.trace('ins pay_element_type_rules');
3160: hr_utility.trace('element_type_id ' ||
3161: to_char(ele_types.element_Type_id));
3162: hr_utility.trace('element_set_id ' ||
3163: to_char(ele_types.element_Set_id));