APPS.OTA_RESOURCE_BOOKING_API dependencies on PER_PEOPLE_F

Line 71: l_person_id per_people_f.person_id%type;

67: l_object_version_number number;
68: l_effective_date date;
69: l_resource_booking_id ota_resource_bookings.resource_booking_id%type ;
70:
71: l_person_id per_people_f.person_id%type;
72:
73: cursor get_trainer_id is
74: select osr.trainer_id from ota_suppliable_resources osr
75: where

Line 391: l_person_id per_people_f.person_id%type;

387: --
388: l_proc varchar2(72) := g_package||' update_resource_booking ';
389: l_object_version_number number := p_object_version_number;
390: l_effective_date date;
391: l_person_id per_people_f.person_id%type;
392:
393: cursor get_res_info
394: is
395: select orb.status,orb.event_id,orb.required_date_from

Line 723: l_person_id per_people_f.person_id%type;

719: l_end_time ota_events.course_start_time%type;
720: l_status varchar2(30);
721: l_event_id ota_events.event_id%type;
722: l_sup_res_id ota_resource_bookings.supplied_resource_id%type;
723: l_person_id per_people_f.person_id%type;
724: --
725: --
726: begin
727: hr_utility.set_location('Entering:'|| l_proc, 10);