DBA Data[Home] [Help]

APPS.HXC_TIMECARD_SEARCH_PKG dependencies on HXC_TIME_ATTRIBUTES

Line 71: || 'hxc_time_attributes hta'

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'
75: || ' AND htau.time_building_block_id = htbb_detail.time_building_block_id'

Line 343: --Bug 4259255. Added exception handling for corrupt data in hxc_time_attributes table.

339:
340: l_return_string := add_value_to_string(l_return_string, l_id_string);
341:
342: END LOOP;
343: --Bug 4259255. Added exception handling for corrupt data in hxc_time_attributes table.
344: --Change for version 115.46
345: exception
346: WHEN INVALID_NUMBER THEN
347: fnd_message.set_name('HXC', 'HXC_INVALID_PROJECT_ID');

Line 500: hxc_time_attributes ta

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 =
504: details.object_version_number

Line 1248: || ' ,hxc_time_attributes hta';

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
1252: l_sql_from := l_sql_from