APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_OFFERINGS

Line 187: OTA_OFFERINGS off,

183: off.activity_version_id,
184: evt.offering_id,
185: nvl(evt.price_basis,NULL)
186: FROM OTA_EVENTS_VL evt,
187: OTA_OFFERINGS off,
188: HR_ALL_ORGANIZATION_UNITS hao
189: WHERE evt.event_id = p_event_id
190: AND off.offering_id = evt.parent_offering_id
191: AND evt.organization_id = hao.organization_id (+);

Line 546: ota_offerings off , ota_events oev

542: l_automatic_transfer_gl varchar2(40);
543:
544: Cursor chk_for_comp_upd is
545: select ocu.online_flag , off.Learning_object_id from ota_category_usages ocu,
546: ota_offerings off , ota_events oev
547: where ocu.category_usage_id = off.delivery_mode_id
548: and off.offering_id = oev.parent_offering_id
549: and oev.event_id = p_event_id;
550:

Line 561: l_LO_id ota_offerings.Learning_object_id%type;

557: and foi.object_id = p_event_id
558: and fr.auto_notification_flag = 'Y';
559: l_comp_upd varchar2(1000) :='MoveToHistoryImage';
560: l_on_flag varchar2(100);
561: l_LO_id ota_offerings.Learning_object_id%type;
562:
563: --Bug 5386501
564: Cursor csr_class_data is
565: Select title from ota_events_vl

Line 1832: ota_offerings off , ota_events oev

1828:
1829: Cursor chk_for_comp_upd
1830: is
1831: select ocu.online_flag , off.Learning_object_id from ota_category_usages ocu,
1832: ota_offerings off , ota_events oev
1833: where ocu.category_usage_id = off.delivery_mode_id
1834: and off.offering_id = oev.parent_offering_id
1835: and oev.event_id = p_event_id;
1836:

Line 1839: l_LO_id ota_offerings.Learning_object_id%type;

1835: and oev.event_id = p_event_id;
1836:
1837: l_comp_upd varchar2(1000) :='MoveToHistoryImage';
1838: l_on_flag varchar2(100);
1839: l_LO_id ota_offerings.Learning_object_id%type;
1840:
1841: cursor get_status_info is
1842: select bst.Type
1843: from ota_booking_status_types bst, ota_delegate_bookings tdb