APPS.PY_FR_ADDITIONAL_ELEMENT_RULES dependencies on PAY_ELEMENT_TYPES_F

Line 28: from pay_element_types_f

24: Begin
25: --
26: select least(effective_start_date),greatest(effective_end_date)
27: into l_effective_start_date,l_effective_end_date
28: from pay_element_types_f
29: where element_type_id =p_element_type_id;
30: --
31: l_input_value_id := pay_db_pay_setup.create_input_value
32: (p_element_name => p_element_name

Line 139: from pay_element_types_f

135: and piv.effective_end_date );
136:
137: cursor class_id is
138: select classification_id
139: from pay_element_types_f
140: where element_type_id =(select element_type_id from pay_input_values_f
141: where input_value_id = p_pto_input_value_id)
142: and rownum = 1;
143:

Line 272: update pay_element_types_f

268: fnd_message.set_token('LOOKUP_TYPE','FR_ELEMENT_GROUP');
269: hr_utility.set_message(801,'PAY_75051_ELEMENT_GROUP');
270: hr_utility.raise_error;
271: Else
272: update pay_element_types_f
273: set element_information1 = 'TERMINATION_HOLIDAY_PAY' -- l_element_group
274: ,element_information_category = 'FR_EARNINGS'
275: ,proration_group_id = l_proration_group_id
276: where element_type_id = l_element_id;

Line 1331: update pay_element_types_f

1327: -- Now update the main acp element to have a processing priority of 9590
1328: --
1329: hr_utility.set_location('Step '||g_package,790);
1330: begin
1331: update pay_element_types_f
1332: set processing_priority = 9590
1333: ,formula_id = nvl(l_new_skip_rule_id, formula_id)
1334: where element_name = p_accrual_plan_name
1335: and business_group_id = p_business_group_id;