eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_CAU_BUS dependencies on HR_CALENDAR_USAGES

Line 110: from hr_calendar_usages

106: --
107: -- Check for overlapping calendar use
108: --
109: select 1
110: from hr_calendar_usages
111: where purpose_usage_id = p_purpose_usage_id
112: and (p_calendar_usage_id is null
113: or p_calendar_usage_id <> calendar_usage_id)
114: and primary_key_value = p_primary_key_value

Line 269: hr_calendar_usages CAU

265: --
266: select cau.purpose_usage_id,
267: cau.primary_key_value
268: from hr_pattern_purpose_usages PPU1,
269: hr_calendar_usages CAU
270: where ppu1.pattern_purpose = (
271: select ppu2.pattern_purpose
272: from hr_pattern_purpose_usages PPU2
273: where ppu2.purpose_usage_id = p_purpose_usage_id

Line 288: from hr_calendar_usages

284: p_purpose_usage_id in number,
285: p_start_date in date) is
286: --
287: select calendar_id
288: from hr_calendar_usages
289: where primary_key_value = p_primary_key_value
290: and purpose_usage_id = p_purpose_usage_id
291: and p_start_date between start_date and end_date;
292: --