APPS.PAY_CA_EOY_RL1_AMEND_ARCH dependencies on PER_ALL_PEOPLE_F

Line 36: 15-NOV-2004 SSouresr 115.6 Using per_all_people_f instead of per_people_f

32: has been specified.
33: 01-SEP-2004 SSouresr 115.4 Added changes for multi assignments
34: 02-SEP-2004 SSouresr 115.5 Changed to use the function get_parameter
35: to retrieve PRE_ORGANIZATION_ID
36: 15-NOV-2004 SSouresr 115.6 Using per_all_people_f instead of per_people_f
37: 07-MAR-2005 SSouresr 115.7 Removed extra p_payroll_action_id from
38: range_cursor
39: 11-OCT-2006 meshah 115.8 5528944 Added order by clause in the range
40: cursor queries.

Line 88: lv_sin per_all_people_f.national_identifier%TYPE;

84: ln_business_group_id NUMBER;
85: ln_pre_org_id NUMBER := 0;
86: ln_person_id NUMBER := 0;
87: ln_asg_set NUMBER := 0;
88: lv_sin per_all_people_f.national_identifier%TYPE;
89: lv_year VARCHAR2(4);
90:
91: BEGIN
92: hr_utility.trace('Entered get_payroll_action_info');

Line 150: lv_sin per_all_people_f.national_identifier%TYPE ;

146: ld_start_date DATE;
147: ln_business_group_id NUMBER;
148: ln_pre_org_id NUMBER;
149: ln_person_id NUMBER := 0;
150: lv_sin per_all_people_f.national_identifier%TYPE ;
151: ln_asg_set NUMBER := 0;
152: lv_year VARCHAR2(4);
153: lv_sql_string VARCHAR2(32000);
154: ln_eoy_pactid number;

Line 257: lv_sin per_all_people_f.national_identifier%TYPE ;

253: ld_start_date DATE;
254: ln_business_group_id NUMBER;
255: ln_person_id NUMBER := 0 ;
256: ln_person_id_sel NUMBER := 0 ;
257: lv_sin per_all_people_f.national_identifier%TYPE ;
258: ln_asg_set NUMBER := 0 ;
259: ln_prev_asg_action_id NUMBER := 0;
260: ln_prev_assignment_id NUMBER := 0;
261: ld_prev_effective_date DATE ;

Line 268: lv_national_identifier per_all_people_f.national_identifier%type;

264:
265:
266: lv_serial_number VARCHAR2(30);
267: ln_eoy_pactid number := 0;
268: lv_national_identifier per_all_people_f.national_identifier%type;
269: lv_message varchar2(100):= null;
270: lv_full_name per_all_people_f.full_name%type;
271: lv_name varchar2(100);
272: lv_record_name varchar2(80);

Line 270: lv_full_name per_all_people_f.full_name%type;

266: lv_serial_number VARCHAR2(30);
267: ln_eoy_pactid number := 0;
268: lv_national_identifier per_all_people_f.national_identifier%type;
269: lv_message varchar2(100):= null;
270: lv_full_name per_all_people_f.full_name%type;
271: lv_name varchar2(100);
272: lv_record_name varchar2(80);
273:
274:

Line 320: from per_all_people_f

316: order by paa.assignment_action_id desc;
317:
318: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
319: select substr(full_name,1,31), substr(national_identifier,1,11)
320: from per_all_people_f
321: where person_id = cp_person_id
322: ORDER BY effective_end_date desc;
323:
324: