APPS.PAY_US_EARNINGS_TEMPLATE dependencies on PAY_ELEMENT_TYPES_F

Line 145: FROM pay_element_types_f

141: WHERE classification_name = p_classification_name;
142:
143: CURSOR c_ele(p_element_name IN VARCHAR2) IS
144: SELECT element_type_id
145: FROM pay_element_types_f
146: WHERE upper(element_name) = upper(p_element_name)
147: AND legislation_code = 'US';
148:
149: CURSOR c_inp_val(p_input_val_name IN VARCHAR2,

Line 517: UPDATE pay_element_types_f

513: l_sf_ele_type_id := get_obj_id('ELE', p_ele_name||' Speacial Features');
514:
515: hr_utility.set_location(l_proc, 150);
516:
517: UPDATE pay_element_types_f
518: SET element_name = p_ele_name
519: ,element_information10 = l_pri_bal_id
520: ,element_information12 = l_hours_bal_id
521: WHERE element_type_id = l_pri_ele_type_id

Line 661: FROM pay_element_types_f

657: l_proc VARCHAR2(60) := 'pay_us_earnings_template.get_obj_id';
658: --
659: CURSOR c_element IS -- Gets the element type id
660: SELECT element_type_id
661: FROM pay_element_types_f
662: WHERE element_name = p_object_name
663: AND business_group_id = g_bg_id;
664: --
665: CURSOR c_get_ipv_id IS -- Gets the input value id