APPS.IRC_PURGE_OLD_DATA_PKG dependencies on PER_ALL_ASSIGNMENTS_F

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 593: per_all_assignments_f asg,

589: per_qualifications qua,
590: per_competence_elements pce,
591: irc_job_basket_items jbo,
592: per_all_people_f per1,
593: per_all_assignments_f asg,
594: per_all_people_f per2
595: where per1.person_id=p_person_id
596: and trunc(sysdate) between per1.effective_start_date and per1.effective_end_date
597: and per1.party_id = per2.party_id

Line 635: from per_all_assignments_f asg, per_all_people_f per

631: l_max_application_date date := null;
632: --
633: cursor csr_last_application_date is
634: select max(asg.effective_start_date)
635: from per_all_assignments_f asg, per_all_people_f per
636: where per.party_id = p_party_id
637: and p_effective_date
638: between per.effective_start_date and per.effective_end_date
639: and asg.person_id = per.person_id

Line 641: and not exists (select 1 from per_all_assignments_f asg2

637: and p_effective_date
638: between per.effective_start_date and per.effective_end_date
639: and asg.person_id = per.person_id
640: and asg.assignment_type = 'A'
641: and not exists (select 1 from per_all_assignments_f asg2
642: where asg.assignment_id = asg2.assignment_id
643: and asg.effective_start_date > asg2.effective_start_date);
644: --
645: begin