APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_FRM_OBJ_INCLUSIONS

Line 408: ota_frm_obj_inclusions foi

404:
405: Cursor csr_forums_for_class is
406: Select fr.forum_id, fr.business_group_id from
407: ota_forums_b fr,
408: ota_frm_obj_inclusions foi
409: where fr.forum_id = foi.forum_id
410: and foi.object_type = 'E'
411: and foi.object_id = p_event_id
412: and fr.auto_notification_flag = 'Y';

Line 1283: from ota_frm_obj_inclusions foi,ota_frm_notif_subscribers fns

1279: --
1280:
1281: cursor c_get_forum_id is
1282: select fns.forum_id,fns.object_version_number
1283: from ota_frm_obj_inclusions foi,ota_frm_notif_subscribers fns
1284: where foi.object_id = l_event_id
1285: and foi.object_Type = 'E'
1286: and foi.forum_id = fns.forum_id
1287: and (fns.person_id = l_person_id or fns.contact_id = l_contact_id);

Line 1350: ota_frm_obj_inclusions foi

1346: Cursor csr_forums_for_class
1347: is
1348: Select fr.forum_id, fr.business_group_id from
1349: ota_forums_b fr,
1350: ota_frm_obj_inclusions foi
1351: where fr.forum_id = foi.forum_id
1352: and foi.object_type = 'E'
1353: and foi.object_id = l_event_id
1354: and fr.auto_notification_flag = 'Y';