APPS.IRC_PURGE_OLD_DATA_PKG dependencies on IRC_COMMUNICATIONS

Line 335: irc_communications ic,

331: cursor csr_irc_cmm is
332: select icm.COMMUNICATION_MESSAGE_ID, icm.OBJECT_VERSION_NUMBER
333: from irc_comm_messages icm,
334: irc_comm_topics ict,
335: irc_communications ic,
336: per_all_assignments_f paf,
337: per_all_people_f ppf
338: where ppf.party_id = p_party_id
339: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 354: irc_communications ic,

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
357: where ppf.party_id = p_party_id
358: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 373: irc_communications ic,

369: -------------------
370: cursor csr_irc_cmt is
371: select ict.COMMUNICATION_TOPIC_ID, ict.OBJECT_VERSION_NUMBER
372: from irc_comm_topics ict,
373: irc_communications ic,
374: per_all_assignments_f paf,
375: per_all_people_f ppf
376: where ppf.party_id = p_party_id
377: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 385: -- For IRC_COMMUNICATIONS

381: where paf1.assignment_id = paf.assignment_id )
382: and ic.object_id = paf.assignment_id
383: and ict.COMMUNICATION_ID = ic.COMMUNICATION_ID;
384:
385: -- For IRC_COMMUNICATIONS
386: ----------------------
387: cursor csr_irc_cmc is
388: select ic.COMMUNICATION_ID, ic.OBJECT_VERSION_NUMBER
389: from irc_communications ic,

Line 389: from irc_communications ic,

385: -- For IRC_COMMUNICATIONS
386: ----------------------
387: cursor csr_irc_cmc is
388: select ic.COMMUNICATION_ID, ic.OBJECT_VERSION_NUMBER
389: from irc_communications ic,
390: per_all_assignments_f paf,
391: per_all_people_f ppf
392: where ppf.party_id = p_party_id
393: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 561: -- Delete from IRC_COMMUNICATIONS

557: ,p_object_version_number => rec_irc_cmt.OBJECT_VERSION_NUMBER
558: );
559: end loop;
560: --
561: -- Delete from IRC_COMMUNICATIONS
562: --
563: for rec_irc_cmc in csr_irc_cmc loop
564: irc_cmc_del.del
565: (p_communication_id => rec_irc_cmc.COMMUNICATION_ID