APPS.PER_PEOPLE_PKG dependencies on PER_ALL_PEOPLE_F

Line 141: from per_all_people_f

137: and effective_end_date = p_effective_end_date
138: and person_id = p_person_id;
139: cursor c_person is
140: select *
141: from per_all_people_f
142: where person_id = p_person_id
143: and p_effective_start_date
144: between effective_start_date
145: and effective_end_date;

Line 148: l_person per_all_people_f%rowtype;

144: between effective_start_date
145: and effective_end_date;
146:
147: --
148: l_person per_all_people_f%rowtype;
149: --
150: l_phone_ovn number;
151: l_phone_id number;
152: l_person_type_id number;

Line 154: l_full_name per_all_people_f.full_name%TYPE;

150: l_phone_ovn number;
151: l_phone_id number;
152: l_person_type_id number;
153: --
154: l_full_name per_all_people_f.full_name%TYPE;
155: l_order_name per_all_people_f.order_name%TYPE;
156: l_global_name per_all_people_f.global_name%TYPE;
157: l_local_name per_all_people_f.local_name%TYPE;
158: l_duplicate_flag varchar2(10);

Line 155: l_order_name per_all_people_f.order_name%TYPE;

151: l_phone_id number;
152: l_person_type_id number;
153: --
154: l_full_name per_all_people_f.full_name%TYPE;
155: l_order_name per_all_people_f.order_name%TYPE;
156: l_global_name per_all_people_f.global_name%TYPE;
157: l_local_name per_all_people_f.local_name%TYPE;
158: l_duplicate_flag varchar2(10);
159: --

Line 156: l_global_name per_all_people_f.global_name%TYPE;

152: l_person_type_id number;
153: --
154: l_full_name per_all_people_f.full_name%TYPE;
155: l_order_name per_all_people_f.order_name%TYPE;
156: l_global_name per_all_people_f.global_name%TYPE;
157: l_local_name per_all_people_f.local_name%TYPE;
158: l_duplicate_flag varchar2(10);
159: --
160: begin

Line 157: l_local_name per_all_people_f.local_name%TYPE;

153: --
154: l_full_name per_all_people_f.full_name%TYPE;
155: l_order_name per_all_people_f.order_name%TYPE;
156: l_global_name per_all_people_f.global_name%TYPE;
157: l_local_name per_all_people_f.local_name%TYPE;
158: l_duplicate_flag varchar2(10);
159: --
160: begin
161: l_phone_ovn := NULL ;

Line 670: ,p_parent_table => 'PER_ALL_PEOPLE_F'

666: ,p_date_to => null
667: ,p_phone_type => 'W1'
668: ,p_phone_number => p_work_telephone
669: ,p_parent_id => p_person_id
670: ,p_parent_table => 'PER_ALL_PEOPLE_F'
671: ,p_validate => FALSE
672: ,p_effective_date => p_start_date
673: ,p_object_version_number => l_phone_ovn --out
674: ,p_phone_id => l_phone_id --out

Line 1310: l_npw_number per_all_people_f.npw_number%TYPE;

1306: l_fire_warning varchar2(1); -- If set Y return to form displaying warning.
1307: l_num_appls NUMBER; -- Number of applicants.
1308: l_num_accepted_appls NUMBER; -- Number of accepted spplicant assignments
1309: l_set_of_books_id NUMBER; -- Required for GL.
1310: l_npw_number per_all_people_f.npw_number%TYPE;
1311: l_party_id per_all_people_f.party_id%type;
1312: --
1313: cursor csr_partyId_details is -- Enh 3299580
1314: select party_id

Line 1311: l_party_id per_all_people_f.party_id%type;

1307: l_num_appls NUMBER; -- Number of applicants.
1308: l_num_accepted_appls NUMBER; -- Number of accepted spplicant assignments
1309: l_set_of_books_id NUMBER; -- Required for GL.
1310: l_npw_number per_all_people_f.npw_number%TYPE;
1311: l_party_id per_all_people_f.party_id%type;
1312: --
1313: cursor csr_partyId_details is -- Enh 3299580
1314: select party_id
1315: from per_all_people_f

Line 1315: from per_all_people_f

1311: l_party_id per_all_people_f.party_id%type;
1312: --
1313: cursor csr_partyId_details is -- Enh 3299580
1314: select party_id
1315: from per_all_people_f
1316: where person_id = p_person_id
1317: and p_session_date between effective_start_date
1318: and effective_end_date;
1319: begin