APPS.IRC_PARTY_PERSON_UTL dependencies on PER_ALL_PEOPLE_F

Line 15: l_object_version_number per_all_people_f.object_version_number%type;

11: l_business_group_id number;
12: l_person_type_id number;
13: l_ptu_person_type_id number;
14: l_new_person_id number;
15: l_object_version_number per_all_people_f.object_version_number%type;
16: l_effective_start_date per_all_people_f.effective_start_date%type;
17: l_effective_end_date per_all_people_f.effective_end_date%type;
18: l_full_name per_all_people_f.full_name%type;
19: l_comment_id per_all_people_f.comment_id%type;

Line 16: l_effective_start_date per_all_people_f.effective_start_date%type;

12: l_person_type_id number;
13: l_ptu_person_type_id number;
14: l_new_person_id number;
15: l_object_version_number per_all_people_f.object_version_number%type;
16: l_effective_start_date per_all_people_f.effective_start_date%type;
17: l_effective_end_date per_all_people_f.effective_end_date%type;
18: l_full_name per_all_people_f.full_name%type;
19: l_comment_id per_all_people_f.comment_id%type;
20: l_name_combination_warning boolean;

Line 17: l_effective_end_date per_all_people_f.effective_end_date%type;

13: l_ptu_person_type_id number;
14: l_new_person_id number;
15: l_object_version_number per_all_people_f.object_version_number%type;
16: l_effective_start_date per_all_people_f.effective_start_date%type;
17: l_effective_end_date per_all_people_f.effective_end_date%type;
18: l_full_name per_all_people_f.full_name%type;
19: l_comment_id per_all_people_f.comment_id%type;
20: l_name_combination_warning boolean;
21: l_orig_hire_warning boolean;

Line 18: l_full_name per_all_people_f.full_name%type;

14: l_new_person_id number;
15: l_object_version_number per_all_people_f.object_version_number%type;
16: l_effective_start_date per_all_people_f.effective_start_date%type;
17: l_effective_end_date per_all_people_f.effective_end_date%type;
18: l_full_name per_all_people_f.full_name%type;
19: l_comment_id per_all_people_f.comment_id%type;
20: l_name_combination_warning boolean;
21: l_orig_hire_warning boolean;
22: l_assign_payroll_warning boolean;

Line 19: l_comment_id per_all_people_f.comment_id%type;

15: l_object_version_number per_all_people_f.object_version_number%type;
16: l_effective_start_date per_all_people_f.effective_start_date%type;
17: l_effective_end_date per_all_people_f.effective_end_date%type;
18: l_full_name per_all_people_f.full_name%type;
19: l_comment_id per_all_people_f.comment_id%type;
20: l_name_combination_warning boolean;
21: l_orig_hire_warning boolean;
22: l_assign_payroll_warning boolean;
23: l_mode boolean;

Line 119: ,per_all_people_f per1

115: and usr1.start_date < sysdate
116: union
117: select usr1.email_address,usr1.start_date
118: from fnd_user usr1
119: ,per_all_people_f per1
120: where usr1.employee_id=per1.person_id
121: and usr1.start_date < sysdate
122: and per1.party_id=p_party_id
123: and trunc(sysdate) between per1.effective_start_date

Line 141: from per_all_people_f

137: l_legislation_code varchar2(150);
138:
139: cursor get_person_rec(p_party_id number) is
140: select person_id,effective_start_date
141: from per_all_people_f
142: where party_id=p_party_id
143: and business_group_id=l_business_group_id
144: order by effective_start_date asc;
145:

Line 148: from per_all_people_f

144: order by effective_start_date asc;
145:
146: cursor get_current_person_rec(p_person_id number) is
147: select email_address,object_version_number
148: from per_all_people_f
149: where person_id=p_person_id
150: and trunc(sysdate) between effective_start_date and effective_end_date;
151:
152: cursor get_ptu_entry(p_person_id number) is

Line 474: ,parent_table='PER_ALL_PEOPLE_F'

470: --
471:
472: update per_phones
473: set parent_id=l_person_ids(i)
474: ,parent_table='PER_ALL_PEOPLE_F'
475: where party_id=l_party_ids(i)
476: and parent_id is null;
477:
478: --