[Home] [Help]
APPS.IRC_NOTIFICATION_DATA_PKG dependencies on IRC_COMM_TOPICS
Line 247: ,IRC_COMM_TOPICS ict
243: || ';IRC_COMM_MSG_BODY:'
244: || icm.MESSAGE_BODY
245: || ';'
246: from IRC_COMM_MESSAGES icm
247: ,IRC_COMM_TOPICS ict
248: where ict.COMMUNICATION_TOPIC_ID = c_topicId
249: and icm.COMMUNICATION_TOPIC_ID = c_topicId
250: and icm.COMMUNICATION_MESSAGE_ID = c_messageId;
251: l_communicationTopicDetails varchar2(10000);