APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_FRM_OBJ_INCLUSIONS

Line 554: ota_frm_obj_inclusions foi

550:
551: Cursor csr_forums_for_class is
552: Select fr.forum_id, fr.business_group_id from
553: ota_forums_b fr,
554: ota_frm_obj_inclusions foi
555: where fr.forum_id = foi.forum_id
556: and foi.object_type = 'E'
557: and foi.object_id = p_event_id
558: and fr.auto_notification_flag = 'Y';

Line 1452: from ota_frm_obj_inclusions foi,ota_frm_notif_subscribers fns

1448: --
1449:
1450: cursor c_get_forum_id is
1451: select fns.forum_id,fns.object_version_number
1452: from ota_frm_obj_inclusions foi,ota_frm_notif_subscribers fns
1453: where foi.object_id = l_event_id
1454: and foi.object_Type = 'E'
1455: and foi.forum_id = fns.forum_id
1456: and (fns.person_id = l_person_id or fns.contact_id = l_contact_id);

Line 1519: ota_frm_obj_inclusions foi

1515: Cursor csr_forums_for_class
1516: is
1517: Select fr.forum_id, fr.business_group_id from
1518: ota_forums_b fr,
1519: ota_frm_obj_inclusions foi
1520: where fr.forum_id = foi.forum_id
1521: and foi.object_type = 'E'
1522: and foi.object_id = l_event_id
1523: and fr.auto_notification_flag = 'Y';