APPS.IRC_PURGE_OLD_DATA_PKG dependencies on IRC_ASSIGNMENT_STATUSES

Line 166: from irc_assignment_statuses ias, per_all_assignments_f asg,

162: l_user_name fnd_user.user_name%type;
163: --
164: cursor csr_ias_del is
165: select ias.assignment_status_id, ias.object_version_number
166: from irc_assignment_statuses ias, per_all_assignments_f asg,
167: per_all_people_f per
168: where asg.assignment_id = ias.assignment_id
169: and p_effective_date between per.effective_start_date
170: and per.effective_end_date

Line 210: -- Delete Irc Assignment Statuses record

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