APPS.IRC_PURGE_OLD_DATA_PKG dependencies on PER_ALL_PEOPLE_F

Line 19: l_full_name per_all_people_f.full_name%type;

15: l_notif_pref_ovn number;
16: l_notif_pref_id number;
17: l_effective_start_date date;
18: l_effective_end_date date;
19: l_full_name per_all_people_f.full_name%type;
20: l_employee_number per_all_people_f.employee_number%type;
21: l_comment_id number;
22: l_name_combination_warning boolean;
23: l_assign_payroll_warning boolean;

Line 20: l_employee_number per_all_people_f.employee_number%type;

16: l_notif_pref_id number;
17: l_effective_start_date date;
18: l_effective_end_date date;
19: l_full_name per_all_people_f.full_name%type;
20: l_employee_number per_all_people_f.employee_number%type;
21: l_comment_id number;
22: l_name_combination_warning boolean;
23: l_assign_payroll_warning boolean;
24: l_orig_hire_warning boolean;

Line 28: from per_all_people_f

24: l_orig_hire_warning boolean;
25: --
26: cursor csr_update_person is
27: select person_id, object_version_number,employee_number,effective_start_date
28: from per_all_people_f
29: where party_id = p_party_id;
30: --
31: cursor csr_update_notif_pref is
32: select object_version_number,notification_preference_id

Line 105: l_name per_all_people_f.full_name%type;

101: l_proc varchar2(72) := 'send_notification_to_person';
102: l_subject fnd_new_messages.message_text%type :=
103: fnd_message.get_string('PER','IRC_412169_PURGE_SUBJECT');
104: l_nid number;
105: l_name per_all_people_f.full_name%type;
106: l_message_conc_html varchar2(15600);
107: l_message_conc_text varchar2(15600);
108: l_usrName varchar2(200);
109: --

Line 112: from per_all_people_f

108: l_usrName varchar2(200);
109: --
110: cursor csr_name is
111: select full_name
112: from per_all_people_f
113: where person_id = p_person_id;
114:
115: cursor csr_getfnduser(l_personIdIn in number) is
116: select user_name

Line 167: per_all_people_f per

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
171: and p_effective_date between asg.effective_start_date

Line 178: from per_all_people_f per

174: and per.party_id = p_party_id;
175: --
176: cursor csr_per_del is
177: select per.person_id
178: from per_all_people_f per
179: where per.party_id = p_party_id
180: and p_effective_date between per.effective_start_date
181: and per.effective_end_date;
182: --

Line 493: l_person_full_name per_all_people_f.full_name%type;

489: ) is
490: --
491: l_proc varchar2(72) := 'notify_or_purge';
492: l_print_element_info varchar2(32000);
493: l_person_full_name per_all_people_f.full_name%type;
494: cursor csr_full_name is
495: select full_name
496: from per_all_people_f
497: where person_id = p_root_person_id

Line 496: from per_all_people_f

492: l_print_element_info varchar2(32000);
493: l_person_full_name per_all_people_f.full_name%type;
494: cursor csr_full_name is
495: select full_name
496: from per_all_people_f
497: where person_id = p_root_person_id
498: and p_effective_date between effective_start_date
499: and effective_end_date;
500: --

Line 592: per_all_people_f per1,

588: per_establishment_attendances esa,
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

Line 594: per_all_people_f per2

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
598: and per2.person_id = asg.person_id(+)

Line 602: and phn.parent_table(+) = 'PER_ALL_PEOPLE_F'

598: and per2.person_id = asg.person_id(+)
599: and per1.person_id = ido.person_id(+)
600: and per1.person_id = addr.person_id(+)
601: and per1.person_id = phn.parent_id(+)
602: and phn.parent_table(+) = 'PER_ALL_PEOPLE_F'
603: and per1.person_id = pem.person_id(+)
604: and per1.person_id = esa.person_id(+)
605: and per1.person_id = qua.person_id(+)
606: and per1.person_id = pce.person_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 657: from per_all_people_f per1

653: --
654: function is_free_to_purge(p_party_id number,p_effective_date date) return string is
655: cursor c1 (p_party_id number,p_effective_date date) is
656: select 1
657: from per_all_people_f per1
658: ,per_person_type_usages_f ptu
659: ,per_person_types ppt
660: where per1.party_id = p_party_id
661: and per1.person_id = ptu.person_id

Line 719: from per_all_people_f per

715: select inp.person_id,
716: inp.party_id
717: from irc_notification_preferences inp
718: where exists (select 1
719: from per_all_people_f per
720: , per_person_type_usages_f ptu,
721: per_person_types ppt
722: where per.party_id=inp.party_id
723: and nvl(per.current_emp_or_apl_flag,'N')='N'

Line 868: from per_all_people_f

864: from fnd_user u
865: where u.employee_id is not null
866: and u.user_id between p_start_pkid and p_end_pkid
867: and not exists(select null
868: from per_all_people_f
869: where person_id = u.employee_id
870: );
871: l_rows_processed number := 0;
872: begin