APPS.PAY_CA_EOY_T4_AMEND_ARCH dependencies on PER_ALL_PEOPLE_F

Line 48: 15-NOV-2004 SSouresr 115.6 Replaced per_people_f with per_all_people_f

44: some unnecessary code and a
45: redundant join on
46: per_all_assignments_f.
47: 01-SEP-2004 SSattini 115.5 Fixed the GSCC errors.
48: 15-NOV-2004 SSouresr 115.6 Replaced per_people_f with per_all_people_f
49: 07-MAR-2005 SSouresr 115.7 Removed extra p_payroll_action_id from
50: the range cursor
51: 11-OCT-2006 meshah 115.8 5528944 Added order by clause in the range
52: cursor queries.

Line 99: lv_sin per_all_people_f.national_identifier%TYPE;

95: ln_business_group_id NUMBER;
96: ln_tax_unit_id NUMBER := 0;
97: ln_person_id NUMBER := 0;
98: ln_asg_set NUMBER := 0;
99: lv_sin per_all_people_f.national_identifier%TYPE;
100: lv_year VARCHAR2(4);
101:
102: BEGIN
103: hr_utility.trace('Entered get_payroll_action_info');

Line 161: lv_sin per_all_people_f.national_identifier%TYPE ;

157: ld_start_date DATE;
158: ln_business_group_id NUMBER;
159: ln_tax_unit_id NUMBER;
160: ln_person_id NUMBER := 0;
161: lv_sin per_all_people_f.national_identifier%TYPE ;
162: ln_asg_set NUMBER := 0;
163: lv_year VARCHAR2(4);
164: lv_sql_string VARCHAR2(32000);
165: lv_record_name varchar2(80);

Line 267: lv_sin per_all_people_f.national_identifier%TYPE ;

263: ld_start_date DATE;
264: ln_business_group_id NUMBER;
265: ln_person_id NUMBER := 0 ;
266: ln_person_id_sel NUMBER := 0 ;
267: lv_sin per_all_people_f.national_identifier%TYPE ;
268: ln_asg_set NUMBER := 0 ;
269: ln_prev_asg_action_id NUMBER := 0;
270: ln_prev_assignment_id NUMBER := 0;
271: ln_prev_tax_unit_id NUMBER := 0;

Line 278: lv_national_identifier per_all_people_f.national_identifier%type;

274: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
275:
276:
277: lv_serial_number VARCHAR2(30);
278: lv_national_identifier per_all_people_f.national_identifier%type;
279: lv_message varchar2(100):= null;
280: lv_full_name per_all_people_f.full_name%type;
281: lv_name varchar2(100);
282: lv_record_name varchar2(80);

Line 280: lv_full_name per_all_people_f.full_name%type;

276:
277: lv_serial_number VARCHAR2(30);
278: lv_national_identifier per_all_people_f.national_identifier%type;
279: lv_message varchar2(100):= null;
280: lv_full_name per_all_people_f.full_name%type;
281: lv_name varchar2(100);
282: lv_record_name varchar2(80);
283:
284:

Line 332: from per_all_people_f

328: order by paa.assignment_action_id desc;
329:
330: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
331: select substr(full_name,1,31), substr(national_identifier,1,11)
332: from per_all_people_f
333: where person_id = cp_person_id
334: ORDER BY effective_end_date desc;
335:
336: