APPS.IRC_PURGE_OLD_DATA_PKG dependencies on IRC_ASSIGNMENT_STATUSES

Line 173: from irc_assignment_statuses ias, per_all_assignments_f asg,

169: l_user_name fnd_user.user_name%type;
170: --
171: cursor csr_ias_del is
172: select ias.assignment_status_id, ias.object_version_number
173: from irc_assignment_statuses ias, per_all_assignments_f asg,
174: per_all_people_f per
175: where asg.assignment_id = ias.assignment_id
176: and asg.person_id = per.person_id
177: and per.party_id = p_party_id;

Line 213: -- Delete Irc Assignment Statuses record

209: username => l_user_name
210: );
211: end if;
212: --
213: -- Delete Irc Assignment Statuses record
214: --
215: for rec_ias in csr_ias_del
216: loop
217: irc_ias_del.del