APPS.IRC_PURGE_OLD_DATA_PKG dependencies on IRC_COMM_RECIPIENTS

Line 348: -- For IRC_COMM_RECIPIENTS

344: and ic.object_id = paf.assignment_id
345: and ict.COMMUNICATION_ID = ic.COMMUNICATION_ID
346: and icm.COMMUNICATION_TOPIC_ID = ict.COMMUNICATION_TOPIC_ID;
347:
348: -- For IRC_COMM_RECIPIENTS
349: -----------------------
350: cursor csr_irc_cmr is
351: select icr.COMMUNICATION_RECIPIENT_ID, icr.OBJECT_VERSION_NUMBER
352: from irc_comm_recipients icr,

Line 352: from irc_comm_recipients icr,

348: -- For IRC_COMM_RECIPIENTS
349: -----------------------
350: cursor csr_irc_cmr is
351: select icr.COMMUNICATION_RECIPIENT_ID, icr.OBJECT_VERSION_NUMBER
352: from irc_comm_recipients icr,
353: irc_comm_topics ict,
354: irc_communications ic,
355: per_all_assignments_f paf,
356: per_all_people_f ppf

Line 543: -- Delete from IRC_COMM_RECIPIENTS

539: ,p_object_version_number => rec_irc_cmm.OBJECT_VERSION_NUMBER
540: );
541: end loop;
542: --
543: -- Delete from IRC_COMM_RECIPIENTS
544: --
545: for rec_irc_cmr in csr_irc_cmr loop
546: irc_cmr_del.del
547: (p_communication_recipient_id => rec_irc_cmr.COMMUNICATION_RECIPIENT_ID