APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on OTA_DELEGATE_BOOKINGS

Line 129: FROM ota_delegate_bookings tdb,

125: btt.name Status,
126: bst.booking_status_type_id status_id,
127: decode(bst.type, 'C', 0,'R',1, 'W',2, 'P',3,'E',4, 'A',5) status_number,
128: nvl(tdb.is_mandatory_enrollment,'N') mandatory_enrollment_flag
129: FROM ota_delegate_bookings tdb,
130: ota_booking_status_types bst,
131: ota_booking_status_types_tl btt
132: WHERE tdb.delegate_person_id = p_learner_id
133: AND tdb.event_id = p_event_id

Line 648: l_booking_id ota_delegate_bookings.booking_id%type;

644: l_booking_status ota_booking_status_types_tl.name%type;
645:
646: l_request_rec get_all_mandatory_enr_requests%rowtype;
647: l_req_member_rec csr_get_request_members%rowtype;
648: l_booking_id ota_delegate_bookings.booking_id%type;
649:
650:
651: l_cost_center_info csr_get_cost_center_info%rowtype;
652: