APPS.OTA_CATALOG_UTIL dependencies on OTA_PVT_FRM_THREAD_USERS

Line 29: ota_pvt_frm_thread_users users

25: and fth.forum_id = p_forum_id
26: UNION ALL
27: select fth.forum_thread_id
28: from ota_forum_threads fth,
29: ota_pvt_frm_thread_users users
30: where fth.forum_thread_id = users.forum_thread_id
31: and fth.private_thread_flag = 'Y'
32: and users.person_id = p_person_id
33: and fth.forum_id = p_forum_id);

Line 79: ota_pvt_frm_thread_users pvtusers

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'
83: and message.forum_thread_id = pvtusers.forum_thread_id