DBA Data[Home] [Help]

APPS.HXC_AP_DETAIL_LINKS_PKG dependencies on HR_GENERAL

Line 152: ( FND_DATE.CANONICAL_TO_DATE( p_blocks(l_index).date_to) <> hr_general.end_of_time )

148: -- we only want to delete detail links for deleted blocks
149: -- with non zero hours otherwise bug 3156317 happens again.
150:
151: IF (
152: ( FND_DATE.CANONICAL_TO_DATE( p_blocks(l_index).date_to) <> hr_general.end_of_time )
153: AND
154: (
155: ( ( NVL(p_blocks(l_index).measure,0) <> 0 ) AND p_blocks(l_index).type = 'MEASURE' )
156: OR

Line 229: and days.date_to = hr_general.end_of_time

225: where days.resource_id = p_rid
226: and trunc(days.stop_time) >= trunc(p_start_time)
227: and trunc(days.start_time) <= trunc(p_stop_time)
228: and days.scope = 'DAY'
229: and days.date_to = hr_general.end_of_time
230: and details.parent_building_block_id = days.time_building_block_id
231: and details.parent_building_block_ovn = days.object_version_number
232: and details.date_to = hr_general.end_of_time
233: and details.scope = 'DETAIL';

Line 232: and details.date_to = hr_general.end_of_time

228: and days.scope = 'DAY'
229: and days.date_to = hr_general.end_of_time
230: and details.parent_building_block_id = days.time_building_block_id
231: and details.parent_building_block_ovn = days.object_version_number
232: and details.date_to = hr_general.end_of_time
233: and details.scope = 'DETAIL';
234:
235: l_resource_id hxc_time_building_blocks.resource_id%type;
236: l_start_time hxc_time_building_blocks.start_time%type;