DBA Data[Home] [Help]

APPS.HXT_TIM_COL_UTIL dependencies on PER_BUSINESS_GROUPS

Line 218: FROM per_business_groups

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)
217: AND ( legislation_code = ( SELECT legislation_code
218: FROM per_business_groups
219: WHERE business_group_id = i_bg_id) or
220: legislation_code is NULL )
221: AND i_date_worked BETWEEN elt.effective_start_date
222: AND elt.effective_end_date ;