APPS.OTA_TAV_API_BUSINESS_RULES dependencies on HR_GENERAL

Line 407: < nvl( p_end_date, hr_general.end_of_time) Then

403: , p_error_txt => 'OTA_13293_TAV_NO_SUP'
404: );
405: --
406: Elsif nvl( v_sup_end_date, hr_api.g_eot)
407: < nvl( p_end_date, hr_general.end_of_time) Then
408: --
409: Close sel_version;
410: --
411: -- ** TEMP ** Add error message with the following text.

Line 455: tav1.start_date and nvl(tav1.end_date, hr_general.end_of_time)

451: from ota_activity_versions tav2
452: where tav2.activity_id = p_activity_id
453: and tav1.activity_version_id <> tav2.activity_version_id
454: and tav2.start_date between
455: tav1.start_date and nvl(tav1.end_date, hr_general.end_of_time)
456: );
457:
458: Begin
459: --