5639: IS
5640: CURSOR csr_element_name
5641: IS
5642: SELECT ettl.element_name
5643: FROM pay_element_types_f_tl ettl
5644: WHERE ettl.LANGUAGE = USERENV ('LANG')
5645: AND ettl.element_type_id = p_element_type_id;
5646:
5647: l_element_name pay_element_types_f_tl.element_name%TYPE;
5643: FROM pay_element_types_f_tl ettl
5644: WHERE ettl.LANGUAGE = USERENV ('LANG')
5645: AND ettl.element_type_id = p_element_type_id;
5646:
5647: l_element_name pay_element_types_f_tl.element_name%TYPE;
5648: BEGIN
5649:
5650: OPEN csr_element_name;
5651: FETCH csr_element_name INTO l_element_name;