DBA Data[Home] [Help]

APPS.HXC_TIMECARD_UTIL dependencies on HR_GENERAL

Line 80: And htb.date_to = hr_general.end_of_time

76: Select 'x'
77: From hxc_time_building_blocks htb
78: Where htb.scope = 'TIMECARD'
79: And htb.type = 'RANGE'
80: And htb.date_to = hr_general.end_of_time
81: And htb.resource_type = 'PERSON'
82: And htb.resource_id = cp_resource_id
83: And htb.start_time = l_period_start);
84:

Line 141: EXIT WHEN (l_period_start > hr_general.end_of_time);

137: p_number_per_fiscal_year,
138: p_duration_in_days);
139: END IF;
140: EXIT WHEN (l_found_first_empty_period = true);
141: EXIT WHEN (l_period_start > hr_general.end_of_time);
142: END LOOP;
143:
144:
145: return (to_char(l_period_start,'YYYY/MM/DD')||'|'||to_char(l_period_end,'YYYY/MM/DD'));