DBA Data[Home] [Help]

APPS.HXT_TIM_COL_UTIL dependencies on PAY_ELEMENT_TYPES_F_TL

Line 212: pay_element_types_f_tl eltt

208: /* SQL query modified for Bug 2597231 */
209: SELECT elt.element_type_id
210: INTO o_element_type_id
211: FROM pay_element_types_f elt,
212: pay_element_types_f_tl eltt
213: WHERE eltt.element_name = i_element_name
214: AND eltt.language = userenv('LANG')
215: AND elt.element_type_id = eltt.element_type_id
216: AND (elt.business_group_id = i_bg_id or elt.business_group_id is null)