APPS.HXC_TIMECARD_SEARCH_PKG dependencies on HXC_TIME_ATTRIBUTE_USAGES

Line 70: || 'hxc_time_attribute_usages htau, '

66:
67: l_user_list_sql := 'SELECT distinct hta.'
68: || p_flex_segment
69: || ' FROM hxc_time_building_blocks htbb_detail, '
70: || 'hxc_time_attribute_usages htau, '
71: || 'hxc_time_attributes hta'
72: || ' WHERE htbb_detail.resource_id = '
73: || ':p_resource_id'
74: || ' AND htbb_detail.date_to = hr_general.end_of_time'

Line 499: hxc_time_attribute_usages tau,

495: FROM DUAL
496: WHERE EXISTS ( SELECT '1'
497: FROM hxc_time_building_blocks days,
498: hxc_time_building_blocks details,
499: hxc_time_attribute_usages tau,
500: hxc_time_attributes ta
501: WHERE tau.time_building_block_id =
502: details.time_building_block_id
503: AND tau.time_building_block_ovn =

Line 1247: || ' ,hxc_time_attribute_usages htau'

1243:
1244: IF NOT l_attribute_flag
1245: THEN
1246: l_sql_from := l_sql_from
1247: || ' ,hxc_time_attribute_usages htau'
1248: || ' ,hxc_time_attributes hta';
1249:
1250: IF NOT l_detail_join_flag
1251: THEN