APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_CATEGORY_USAGES

Line 545: select ocu.online_flag , off.Learning_object_id from ota_category_usages ocu,

541: l_result_finance_header_id number;
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;

Line 1831: select ocu.online_flag , off.Learning_object_id from ota_category_usages ocu,

1827: l_ignore_dff_validation varchar2(1);
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;