APPS.IRC_NOTIFICATION_DATA_PKG dependencies on IRC_COMM_TOPICS

Line 258: ,IRC_COMM_TOPICS ict

254: || icm.MESSAGE_SUBJECT
255: || ';IRC_COMM_MSG_BODY:'
256: || substr(icm.MESSAGE_BODY,1,1000)
257: from IRC_COMM_MESSAGES icm
258: ,IRC_COMM_TOPICS ict
259: where ict.COMMUNICATION_TOPIC_ID = c_topicId
260: and icm.COMMUNICATION_TOPIC_ID = c_topicId
261: and icm.COMMUNICATION_MESSAGE_ID = c_messageId;
262: