APPS.HXC_TIMEKEEPER_ERRORS dependencies on HR_GENERAL

Line 32: AND detail.date_to = hr_general.end_of_time

28: detail.measure measure
29: FROM hxc_time_building_blocks detail, hxc_time_building_blocks DAY
30: WHERE DAY.parent_building_block_id = p_timecard_id
31: AND DAY.parent_building_block_ovn = p_timecard_ovn
32: AND detail.date_to = hr_general.end_of_time
33: AND detail.SCOPE = 'DETAIL'
34: AND detail.parent_building_block_id = DAY.time_building_block_id
35: AND detail.parent_building_block_ovn = DAY.object_version_number
36: AND DAY.SCOPE = 'DAY'

Line 37: AND DAY.date_to = hr_general.end_of_time

33: AND detail.SCOPE = 'DETAIL'
34: AND detail.parent_building_block_id = DAY.time_building_block_id
35: AND detail.parent_building_block_ovn = DAY.object_version_number
36: AND DAY.SCOPE = 'DAY'
37: AND DAY.date_to = hr_general.end_of_time
38: UNION
39: SELECT time_building_block_id detail_id,
40: object_version_number detail_ovn,
41: scope,

Line 91: (tke.date_to=hr_general.end_of_time OR tke.date_to is NULL);

87: hxc_errors tke
88: WHERE
89: tke.time_building_block_id = p_tbb_id AND
90: tke.time_building_block_ovn = p_ovn_id AND
91: (tke.date_to=hr_general.end_of_time OR tke.date_to is NULL);
92:
93:
94: l_tbb_id number(15);
95: l_tbb_ovn number(15);

Line 229: and (date_to=hr_general.end_of_time OR date_to is NULL);

225: select *
226: from hxc_errors
227: where time_building_block_id = p_tbb_id
228: and time_building_block_ovn = p_tbb_ovn
229: and (date_to=hr_general.end_of_time OR date_to is NULL);
230:
231: CURSOR c_detail_info (timecard_id IN NUMBER, timecard_ovn IN NUMBER)
232: IS
233: SELECT detail.time_building_block_id detail_id,

Line 238: AND detail.date_to = hr_general.end_of_time

234: detail.object_version_number detail_ovn
235: FROM hxc_time_building_blocks detail, hxc_time_building_blocks DAY
236: WHERE DAY.parent_building_block_id = timecard_id
237: AND DAY.parent_building_block_ovn = timecard_ovn
238: AND detail.date_to = hr_general.end_of_time
239: AND detail.SCOPE = 'DETAIL'
240: AND detail.parent_building_block_id = DAY.time_building_block_id
241: AND detail.parent_building_block_ovn = DAY.object_version_number
242: AND DAY.SCOPE = 'DAY'

Line 243: AND DAY.date_to = hr_general.end_of_time;

239: AND detail.SCOPE = 'DETAIL'
240: AND detail.parent_building_block_id = DAY.time_building_block_id
241: AND detail.parent_building_block_ovn = DAY.object_version_number
242: AND DAY.SCOPE = 'DAY'
243: AND DAY.date_to = hr_general.end_of_time;
244:
245: l_proc varchar2(72);
246:
247: l_message_index NUMBER;

Line 385: ,p_date_to => hr_general.end_of_time

381: ,p_application_short_name =>p_messages(l_message_index).application_short_name
382: ,p_error_id => l_error_id
383: ,p_object_version_number => l_ovn
384: ,p_date_from => sysdate
385: ,p_date_to => hr_general.end_of_time
386: );
387: End if;
388: l_message_index := p_messages.NEXT(l_message_index);
389: