APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on PAY_ELEMENT_TYPES_F_TL

Line 524: FROM pay_element_types_f pet, pay_element_types_f_tl petl

520: --
521: BEGIN
522: SELECT petl.element_name
523: INTO l_element_name
524: FROM pay_element_types_f pet, pay_element_types_f_tl petl
525: WHERE pet.element_type_id = p_ele_type_id
526: AND petl.element_type_id = pet.element_type_id
527: AND USERENV ('LANG') = petl.LANGUAGE
528: AND p_effective_date BETWEEN pet.effective_start_date