APPS.OTA_TDB_BUS2 dependencies on HR_API

Line 705: and nvl(effective_end_date,hr_api.g_eot);

701: from per_all_people_f
702: where person_id = p_delegate_person_id
703: and trunc(p_date_booking_placed)
704: between effective_start_date
705: and nvl(effective_end_date,hr_api.g_eot);
706: --
707: cursor c_sponsor is
708: select effective_start_date, effective_end_date
709: from per_all_people_f

Line 713: and nvl(effective_end_date,hr_api.g_eot);

709: from per_all_people_f
710: where person_id = p_sponsor_person_id
711: and p_date_booking_placed
712: between effective_start_date
713: and nvl(effective_end_date,hr_api.g_eot);
714: --
715: Begin
716: hr_utility.set_location('Entering:'||l_proc, 5);
717: --

Line 749: (nvl(l_delegate_end_date,hr_api.g_eot)

745: hr_utility.set_location('Event Start Date'||to_char(l_event_start_date),5);
746:
747: /*
748: if (l_delegate_start_date > p_date_booking_placed) or
749: (nvl(l_delegate_end_date,hr_api.g_eot)
750: < p_date_booking_placed) or
751: (l_delegate_start_date > l_event_start_date) then
752: */
753: --

Line 773: (nvl(l_sponsor_end_date,hr_api.g_eot)

769: --
770: -- Check if sponsor is valid for session dates
771: --
772: if (l_sponsor_start_date > p_date_booking_placed) or
773: (nvl(l_sponsor_end_date,hr_api.g_eot)
774: < p_date_booking_placed) then
775: --
776: -- Sponsor is not valid, display error
777: --