APPS.OTA_RUD_BUS dependencies on HR_GENERAL

Line 271: and nvl (l_off_end_date, hr_general.end_of_time)) then

267: -- Start date in range ?
268: --
269: if (p_start_date
270: not between l_off_start_date
271: and nvl (l_off_end_date, hr_general.end_of_time)) then
272: ota_rud_shd.constraint_error ('OTA_RUD_TAV_DATES');
273: end if;
274: --
275: -- End date in range ?

Line 280: and nvl (l_off_end_date, hr_general.end_of_time))) then

276: --
277: if ( (p_end_date is not null)
278: and (p_end_date
279: not between l_off_start_date
280: and nvl (l_off_end_date, hr_general.end_of_time))) then
281: ota_rud_shd.constraint_error ('OTA_RUD_TAV_DATES');
282: end if;
283: --
284: hr_utility.set_location (' leaving:' || l_proc, 5);

Line 328: and nvl (l_tsr_end_date, hr_general.end_of_time)) then

324: -- Start date in range ?
325: --
326: if (p_start_date
327: not between l_tsr_start_date
328: and nvl (l_tsr_end_date, hr_general.end_of_time)) then
329: ota_rud_shd.constraint_error ('OTA_RUD_TSR_DATES');
330: end if;
331: --
332: -- End date in range ?

Line 337: and nvl (l_tsr_end_date, hr_general.end_of_time))) then

333: --
334: if ( (p_end_date is not null)
335: and (p_end_date
336: not between l_tsr_start_date
337: and nvl (l_tsr_end_date, hr_general.end_of_time))) then
338: ota_rud_shd.constraint_error ('OTA_RUD_TSR_DATES');
339: end if;
340: --
341: hr_utility.set_location (' leaving:' || l_proc, 10);