APPS.PQP_GB_PROFESSIONAL_BODY_TEMP dependencies on PAY_ELEMENT_TYPES_F

Line 54: l_ele_name pay_element_types_f.element_name%TYPE;

50: l_eei_info_id NUMBER;
51: l_ovn_eei NUMBER;
52: l_element_type_id NUMBER;
53: l_ele_obj_ver_number NUMBER;
54: l_ele_name pay_element_types_f.element_name%TYPE;
55: l_name pay_input_values_f.name%TYPE;
56: i NUMBER;
57:
58: l_ele_core_id pay_template_core_objects.core_object_id%TYPE:= -1;

Line 235: FROM pay_element_types_f

231: l_proc varchar2(60) := 'pqp_gb_professional_body_temp.get_object_id';
232: --
233: CURSOR csr_get_ele_type_id (c_object_name varchar2) is
234: SELECT element_type_id
235: FROM pay_element_types_f
236: WHERE element_name = c_object_name
237: AND business_group_id = p_bg_id;
238: --
239: CURSOR csr_core_bal_id (c_object_name in varchar2) is