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 105: lv_sin per_all_people_f.national_identifier%TYPE;

101: ln_business_group_id NUMBER;
102: ln_tax_unit_id NUMBER := 0;
103: ln_person_id NUMBER := 0;
104: ln_asg_set NUMBER := 0;
105: lv_sin per_all_people_f.national_identifier%TYPE;
106: lv_year VARCHAR2(4);
107:
108: BEGIN
109: hr_utility.trace('Entered get_payroll_action_info');

Line 198: lv_sin per_all_people_f.national_identifier%TYPE;

194: ln_business_group_id NUMBER;
195: ln_tax_unit_id NUMBER := 0;
196: ln_person_id NUMBER := 0;
197: ln_asg_set NUMBER := 0;
198: lv_sin per_all_people_f.national_identifier%TYPE;
199: lv_year VARCHAR2(4);
200: -- Variables declared for bug 10399514
201: lv_report_type pay_payroll_actions.report_type%type;
202: lv_report_qualifier pay_payroll_actions.report_qualifier%type;

Line 278: lv_sin per_all_people_f.national_identifier%TYPE ;

274: ld_start_date DATE;
275: ln_business_group_id NUMBER;
276: ln_tax_unit_id NUMBER;
277: ln_person_id NUMBER := 0;
278: lv_sin per_all_people_f.national_identifier%TYPE ;
279: ln_asg_set NUMBER := 0;
280: lv_year VARCHAR2(4);
281: lv_sql_string VARCHAR2(32000);
282: lv_record_name varchar2(80);

Line 385: lv_sin per_all_people_f.national_identifier%TYPE ;

381: ld_start_date DATE;
382: ln_business_group_id NUMBER;
383: ln_person_id NUMBER := 0 ;
384: ln_person_id_sel NUMBER := 0 ;
385: lv_sin per_all_people_f.national_identifier%TYPE ;
386: ln_asg_set NUMBER := 0 ;
387: ln_prev_asg_action_id NUMBER := 0;
388: ln_prev_assignment_id NUMBER := 0;
389: ln_prev_tax_unit_id NUMBER := 0;

Line 402: lv_national_identifier per_all_people_f.national_identifier%type;

398: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
399:
400:
401: lv_serial_number VARCHAR2(30);
402: lv_national_identifier per_all_people_f.national_identifier%type;
403: lv_message varchar2(100):= null;
404: lv_full_name per_all_people_f.full_name%type;
405: lv_name varchar2(100);
406: lv_record_name varchar2(80);

Line 404: lv_full_name per_all_people_f.full_name%type;

400:
401: lv_serial_number VARCHAR2(30);
402: lv_national_identifier per_all_people_f.national_identifier%type;
403: lv_message varchar2(100):= null;
404: lv_full_name per_all_people_f.full_name%type;
405: lv_name varchar2(100);
406: lv_record_name varchar2(80);
407:
408:

Line 485: from per_all_people_f

481: order by paa.assignment_action_id desc;
482:
483: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
484: select substr(full_name,1,31), substr(national_identifier,1,11)
485: from per_all_people_f
486: where person_id = cp_person_id
487: ORDER BY effective_end_date desc;
488:
489: