DBA Data[Home] [Help]

APPS.PQH_GSP_UTILITY dependencies on PAY_ELEMENT_TYPES_F_TL

Line 5643: FROM pay_element_types_f_tl ettl

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;

Line 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;