APPS.HXC_BLOCK_COLLECTION_UTILS dependencies on HR_GENERAL

Line 159: and date_to = hr_general.end_of_time;

155: translation_display_key
156: )
157: from hxc_time_building_blocks
158: where time_building_block_id = p_block_id
159: and date_to = hr_general.end_of_time;
160:
161: Begin
162: if(p_blocks is null) then
163: p_blocks := hxc_block_table_type();

Line 222: and days.date_to = hr_general.end_of_time

218: and top_level.object_version_number = p_top_level_block_ovn
219: and days.resource_id = top_level.resource_id
220: and trunc(days.start_time) between trunc(top_level.start_time) and trunc(top_level.stop_time)
221: and days.scope = 'DAY'
222: and days.date_to = hr_general.end_of_time
223: and days.start_time >= p_start_time
224: and days.stop_time <= p_stop_time
225: and exists
226: (select 'Y'

Line 230: and timecard_check.date_to = hr_general.end_of_time

226: (select 'Y'
227: from hxc_time_building_blocks timecard_check
228: where timecard_check.scope = 'TIMECARD'
229: and timecard_check.resource_id = days.resource_id
230: and timecard_check.date_to = hr_general.end_of_time
231: and timecard_check.time_building_block_id = days.parent_building_block_id
232: and timecard_check.object_version_number = days.parent_building_block_ovn
233: )
234: order by days.start_time;

Line 441: and details.date_to = hr_general.end_of_time;

437: and days.stop_time <= p_stop_time
438: and days.time_building_block_id = details.parent_building_block_id
439: and days.object_version_number = details.parent_building_block_ovn
440: and adl.application_period_id = p_app_period_id
441: and details.date_to = hr_general.end_of_time;
442:
443: l_detail_blocks hxc_block_table_type;
444: l_detail_index pls_integer;
445:

Line 513: and details.date_to = hr_general.end_of_time;

509: details.translation_display_key)
510: from hxc_time_building_blocks details
511: where details.parent_building_block_id = p_day_id
512: and details.parent_building_block_ovn = p_day_ovn
513: and details.date_to = hr_general.end_of_time;
514:
515: l_day_index binary_integer;
516: l_detail_blocks hxc_block_table_type;
517: l_detail_index pls_integer;

Line 697: hr_general.decode_lookup('HXC_APPROVAL_STATUS', apsum.approval_status),

693: p.full_name,
694: '',
695: '',
696: '',
697: hr_general.decode_lookup('HXC_APPROVAL_STATUS', apsum.approval_status),
698: '',
699: '',
700: '' ,
701: '' ,

Line 739: and p.effective_end_date (+) = hr_general.end_of_time

735: and favtl.application_id = htr.application_id
736: and htr.time_recipient_id = apsum.time_recipient_id
737: and favtl.language = userenv('LANG')
738: and p.person_id (+) = apsum.approver_id
739: and p.effective_end_date (+) = hr_general.end_of_time
740: and bbit.bld_blk_info_type = 'APPROVAL';
741:
742: l_row_data hxc_trans_display_key_utils.translation_row_used;
743: l_missing_rows boolean;