APPS.NTG_EARNINGS_TEMPLATE dependencies on PAY_ELEMENT_TYPES_F

Line 106: FROM pay_element_types_f

102: l_proc VARCHAR2(60) := 'ntg_earnings_template.get_obj_id';
103: --
104: CURSOR c_element IS -- Gets the element type id
105: SELECT element_type_id
106: FROM pay_element_types_f
107: WHERE element_name = p_object_name
108: AND business_group_id+0 = p_bg_id;
109: --
110: CURSOR c_get_ipv_id IS -- Gets the input value id

Line 344: UPDATE pay_element_types_f

340: CLOSE c_iter_formula_id;
341: ----------------------------------------------
342: -- Set iterative formula and Termination Rule
343: ----------------------------------------------
344: UPDATE pay_element_types_f
345: SET element_information10 = l_pri_bal_id,
346: iterative_formula_id = l_iter_formula_id,
347: iterative_flag = 'Y',
348: iterative_priority = 5 ,

Line 446: from pay_element_types_f

442: hr_utility.set_location('select element type id', 136);
443:
444: Select element_type_id
445: into l_seeded_ele_type_id
446: from pay_element_types_f
447: where upper(element_name) = 'FIT_GROSSUP_ADJUSTMENT'
448: and legislation_code = 'US';
449:
450: hr_utility.set_location('element type id' || l_seeded_ele_type_id , 137);