APPS.PQP_EARNINGS_TEMPLATE dependencies on PAY_ELEMENT_TYPES_F

Line 314: UPDATE pay_element_types_f

310: l_si_ele_type_id := get_obj_id('ELE',p_ele_name||' Special Inputs');
311: l_ssf_ele_type_id := get_obj_id('ELE',p_ele_name||' Supp SF');
312: l_asf_ele_type_id := get_obj_id('ELE',p_ele_name||' Alien SF');
313: --
314: UPDATE pay_element_types_f
315: SET element_information10 = l_pri_bal_id
316: ,element_information12 = l_hours_bal_id
317: ,element_information13 = p_reduce_regular
318: ,element_information14 = p_supp_category

Line 359: UPDATE pay_element_types_f

355: -- Update the Further Information for the Alien Supplemental element
356: --------------------------------------------------------------------
357: l_supp_bal_id := get_obj_id('BAL', p_ele_name||' Supp');
358: --
359: UPDATE pay_element_types_f
360: SET element_information10 = l_supp_bal_id
361: WHERE element_type_id = l_ssf_ele_type_id
362: AND business_group_id = p_bg_id;
363:

Line 506: FROM pay_element_types_f

502: l_proc VARCHAR2(60) := 'pqp_earnings_template.get_obj_id';
503: --
504: CURSOR c_element IS -- Gets the element type id
505: SELECT element_type_id
506: FROM pay_element_types_f
507: WHERE element_name = p_object_name
508: AND business_group_id = g_bg_id;
509: --
510: CURSOR c_get_ipv_id IS -- Gets the input value id

Line 577: FROM pay_element_types_f pet,

573: AND pbt.balance_name not in ('FLSA Earnings', 'FLSA Hours')
574: AND pbt.balance_type_id = pbf.balance_type_id
575: AND pbf.input_value_id IN
576: (SELECT piv.input_value_id
577: FROM pay_element_types_f pet,
578: pay_input_values_f piv
579: WHERE pet.element_name IN ('Regular Salary', 'Regular Wages')
580: AND p_ele_eff_start_date BETWEEN pet.effective_start_date
581: AND pet.effective_end_date