DBA Data[Home] [Help]

APPS.PQH_GSP_UTILITY dependencies on PAY_ELEMENT_TYPES_F_TL

Line 5524: FROM pay_element_types_f_tl ettl

5520: IS
5521: CURSOR csr_element_name
5522: IS
5523: SELECT ettl.element_name
5524: FROM pay_element_types_f_tl ettl
5525: WHERE ettl.LANGUAGE = USERENV ('LANG')
5526: AND ettl.element_type_id = p_element_type_id;
5527:
5528: l_element_name pay_element_types_f_tl.element_name%TYPE;

Line 5528: l_element_name pay_element_types_f_tl.element_name%TYPE;

5524: FROM pay_element_types_f_tl ettl
5525: WHERE ettl.LANGUAGE = USERENV ('LANG')
5526: AND ettl.element_type_id = p_element_type_id;
5527:
5528: l_element_name pay_element_types_f_tl.element_name%TYPE;
5529: BEGIN
5530:
5531: OPEN csr_element_name;
5532: FETCH csr_element_name INTO l_element_name;