APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_OFFERINGS

Line 175: OTA_OFFERINGS off,

171: off.activity_version_id,
172: evt.offering_id,
173: nvl(evt.price_basis,NULL)
174: FROM OTA_EVENTS_VL evt,
175: OTA_OFFERINGS off,
176: HR_ALL_ORGANIZATION_UNITS hao
177: WHERE evt.event_id = p_event_id
178: AND off.offering_id = evt.parent_offering_id
179: AND evt.organization_id = hao.organization_id (+);

Line 400: ota_offerings off , ota_events oev

396: l_automatic_transfer_gl varchar2(40);
397:
398: Cursor chk_for_comp_upd is
399: select ocu.online_flag , off.Learning_object_id from ota_category_usages ocu,
400: ota_offerings off , ota_events oev
401: where ocu.category_usage_id = off.delivery_mode_id
402: and off.offering_id = oev.parent_offering_id
403: and oev.event_id = p_event_id;
404:

Line 415: l_LO_id ota_offerings.Learning_object_id%type;

411: and foi.object_id = p_event_id
412: and fr.auto_notification_flag = 'Y';
413: l_comp_upd varchar2(1000) :='MoveToHistoryImage';
414: l_on_flag varchar2(100);
415: l_LO_id ota_offerings.Learning_object_id%type;
416:
417: --Bug 5386501
418: Cursor csr_class_data is
419: Select title from ota_events_vl

Line 1662: ota_offerings off , ota_events oev

1658:
1659: Cursor chk_for_comp_upd
1660: is
1661: select ocu.online_flag , off.Learning_object_id from ota_category_usages ocu,
1662: ota_offerings off , ota_events oev
1663: where ocu.category_usage_id = off.delivery_mode_id
1664: and off.offering_id = oev.parent_offering_id
1665: and oev.event_id = p_event_id;
1666:

Line 1669: l_LO_id ota_offerings.Learning_object_id%type;

1665: and oev.event_id = p_event_id;
1666:
1667: l_comp_upd varchar2(1000) :='MoveToHistoryImage';
1668: l_on_flag varchar2(100);
1669: l_LO_id ota_offerings.Learning_object_id%type;
1670:
1671: cursor get_status_info is
1672: select bst.Type
1673: from ota_booking_status_types bst, ota_delegate_bookings tdb