APPS.PQP_UK_VEHICLE_TEMPLATE dependencies on PAY_ELEMENT_TYPES_F

Line 159: pay_element_types_f pet

155: SELECT input_value_id,
156: piv.name,
157: piv.element_type_id
158: FROM pay_input_values_f piv,
159: pay_element_types_f pet
160: WHERE element_name= p_ele_name||' '||lc_sub_type
161: AND piv.element_type_id=pet.element_type_id
162: AND (piv.business_group_id =p_bg_id OR piv.business_group_id IS NULL)
163: AND piv.name =lc_name

Line 359: pay_element_types_f pet

355: SELECT input_value_id,
356: piv.name,
357: piv.element_type_id
358: FROM pay_input_values_f piv,
359: pay_element_types_f pet
360: WHERE piv.element_type_id =p_ele_type
361: AND piv.element_type_id = pet.element_type_id
362: AND piv.business_group_id = p_bg_id
363: AND piv.name =p_inputname;

Line 449: FROM pay_element_types_f

445: l_proc varchar2(60) := 'pqp_uk_vehicle_template.get_object_id';
446: --
447: CURSOR c2 (c_object_name varchar2) is
448: SELECT element_type_id
449: FROM pay_element_types_f
450: WHERE element_name = c_object_name
451: AND business_group_id = p_bg_id;
452: --
453: CURSOR c3 (c_object_name in varchar2) is