APPS.IRC_CMT_BUS dependencies on IRC_COMMUNICATIONS

Line 264: select status from irc_communications where

260: --
261: l_proc varchar2(72) := g_package||'chk_communication_id';
262: l_status irc_comm_topics.status%type;
263: cursor csr_comm(p_comm_id in number) is
264: select status from irc_communications where
265: communication_id = p_comm_id;
266: --
267: --
268: Begin