DBA Data[Home] [Help]

APPS.HXC_APPROVAL_WF_HELPER dependencies on HR_GENERAL

Line 156: where date_to=hr_general.END_of_time

152: select distinct last_updated_by
153: from hxc_time_building_blocks
154: where last_update_date = (select max(last_update_date)
155: from HXC_TIME_BUILDING_BLOCKS
156: where date_to=hr_general.END_of_time
157: connect by prior time_building_block_id=parent_building_block_id
158: start with time_building_block_id=p_timecard_id)
159: and date_to=hr_general.END_of_time
160: connect by prior time_building_block_id=parent_building_block_id

Line 159: and date_to=hr_general.END_of_time

155: from HXC_TIME_BUILDING_BLOCKS
156: where date_to=hr_general.END_of_time
157: connect by prior time_building_block_id=parent_building_block_id
158: start with time_building_block_id=p_timecard_id)
159: and date_to=hr_general.END_of_time
160: connect by prior time_building_block_id=parent_building_block_id
161: start with time_building_block_id=p_timecard_id;
162:
163: BEGIN