DBA Data[Home] [Help]

APPS.HXT_INTERFACE_UTILITIES dependencies on PAY_ELEMENT_TYPES_F_TL

Line 1898: FROM pay_element_types_f petf, pay_element_types_f_tl petft

1894: p_effective_date pay_element_types_f.effective_start_date%TYPE
1895: )
1896: IS
1897: SELECT petft.element_name
1898: FROM pay_element_types_f petf, pay_element_types_f_tl petft
1899: WHERE petf.element_type_id = p_ele_type_id
1900: AND petft.element_type_id = petf.element_type_id
1901: AND USERENV ('LANG') = petft.LANGUAGE
1902: AND p_effective_date BETWEEN petf.effective_start_date