APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on PAY_ELEMENT_TYPES_F_TL

Line 1026: FROM pay_element_types_f pet, pay_element_types_f_tl petl

1022: --
1023: BEGIN
1024: SELECT petl.element_name
1025: INTO l_element_name
1026: FROM pay_element_types_f pet, pay_element_types_f_tl petl
1027: WHERE pet.element_type_id = p_ele_type_id
1028: AND petl.element_type_id = pet.element_type_id
1029: AND USERENV ('LANG') = petl.LANGUAGE
1030: AND p_effective_date BETWEEN pet.effective_start_date