DBA Data[Home] [Help]

APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_CATEGORY_USAGES

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

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

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

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