DBA Data[Home] [Help]

APPS.HR_CAU_BUS dependencies on HR_CALENDARS

Line 26: from hr_calendars

22: --
23: -- Check the usage start/end dates
24: --
25: select calendar_start_time
26: from hr_calendars
27: where calendar_id = p_calendar_id;
28: --
29: l_proc varchar2(72) := g_package||'chk_start_date';
30: l_calendar_start_time date := null;

Line 187: hr_calendars CAL

183: --
184: select 1
185: from hr_pattern_constructions CON,
186: hr_pattern_constructions CON2,
187: hr_calendars CAL
188: where cal.calendar_id = p_calendar_id
189: and cal.pattern_id = con.pattern_id
190: and con.component_pattern_id = con2.pattern_id (+)
191: and (nvl (con.availability,con2.availability)