APPS.OTA_CATALOG_UTIL dependencies on OTA_FORUM_MESSAGES

Line 72: from ota_forum_messages message, ota_forum_threads threads

68: select count(message_id)
69: from
70: (
71: select message.forum_message_id message_id
72: from ota_forum_messages message, ota_forum_threads threads
73: where message.forum_thread_id = threads.forum_thread_id
74: and threads.private_thread_flag = 'N'
75: and message.forum_id = p_forum_id
76: UNION ALL

Line 78: from ota_forum_messages message, ota_forum_threads threads,

74: and threads.private_thread_flag = 'N'
75: and message.forum_id = p_forum_id
76: UNION ALL
77: select message.forum_message_id message_id
78: from ota_forum_messages message, ota_forum_threads threads,
79: ota_pvt_frm_thread_users pvtusers
80: where message.forum_thread_id = threads.forum_thread_id
81: and threads.forum_id = p_forum_id
82: and threads.private_thread_flag = 'Y'

Line 128: from ota_forum_messages message, ota_forum_threads thread

124: -- Declare cursor
125: --
126: Cursor cur_forum_last_post_date is
127: select max(message.creation_date)
128: from ota_forum_messages message, ota_forum_threads thread
129: where message.forum_thread_id = thread.forum_thread_id
130: and message.forum_id = p_forum_id;
131: --
132: -- Declare local variables