APPS.OTA_TDB_API_UPD2 dependencies on OTA_FRM_OBJ_INCLUSIONS

Line 153: from ota_frm_obj_inclusions foi,ota_frm_notif_subscribers fns

149: --
150:
151: cursor c_get_forum_id is
152: select fns.forum_id,fns.object_version_number
153: from ota_frm_obj_inclusions foi,ota_frm_notif_subscribers fns
154: where foi.object_id = l_event_id
155: and foi.object_Type = 'E'
156: and foi.forum_id = fns.forum_id
157: and (fns.person_id = l_person_id or fns.contact_id = l_contact_id);

Line 220: ota_frm_obj_inclusions foi

216: Cursor csr_forums_for_class
217: is
218: Select fr.forum_id, fr.business_group_id from
219: ota_forums_b fr,
220: ota_frm_obj_inclusions foi
221: where fr.forum_id = foi.forum_id
222: and foi.object_type = 'E'
223: and foi.object_id = l_event_id
224: and fr.auto_notification_flag = 'Y';