APPS.PAY_CA_EOY_RL2_AMEND_ARCH dependencies on PER_ALL_PEOPLE_F

Line 78: lv_sin per_all_people_f.national_identifier%TYPE;

74: ln_business_group_id NUMBER;
75: ln_pre_org_id NUMBER := 0;
76: ln_person_id NUMBER := 0;
77: ln_asg_set NUMBER := 0;
78: lv_sin per_all_people_f.national_identifier%TYPE;
79: lv_year VARCHAR2(4);
80:
81: BEGIN
82: hr_utility.trace('Entered get_payroll_action_info');

Line 140: lv_sin per_all_people_f.national_identifier%TYPE ;

136: ld_start_date DATE;
137: ln_business_group_id NUMBER;
138: ln_pre_org_id NUMBER;
139: ln_person_id NUMBER := 0;
140: lv_sin per_all_people_f.national_identifier%TYPE ;
141: ln_asg_set NUMBER := 0;
142: lv_year VARCHAR2(4);
143: lv_sql_string VARCHAR2(32000);
144: ln_eoy_pactid number;

Line 247: lv_sin per_all_people_f.national_identifier%TYPE ;

243: ld_start_date DATE;
244: ln_business_group_id NUMBER;
245: ln_person_id NUMBER := 0 ;
246: ln_person_id_sel NUMBER := 0 ;
247: lv_sin per_all_people_f.national_identifier%TYPE ;
248: ln_asg_set NUMBER := 0 ;
249: ln_prev_asg_action_id NUMBER := 0;
250: ln_prev_assignment_id NUMBER := 0;
251: ld_prev_effective_date DATE ;

Line 258: lv_national_identifier per_all_people_f.national_identifier%type;

254:
255:
256: lv_serial_number VARCHAR2(30);
257: ln_eoy_pactid number := 0;
258: lv_national_identifier per_all_people_f.national_identifier%type;
259: lv_message varchar2(100):= null;
260: lv_full_name per_all_people_f.full_name%type;
261: lv_name varchar2(100);
262: lv_record_name varchar2(80);

Line 260: lv_full_name per_all_people_f.full_name%type;

256: lv_serial_number VARCHAR2(30);
257: ln_eoy_pactid number := 0;
258: lv_national_identifier per_all_people_f.national_identifier%type;
259: lv_message varchar2(100):= null;
260: lv_full_name per_all_people_f.full_name%type;
261: lv_name varchar2(100);
262: lv_record_name varchar2(80);
263:
264:

Line 310: from per_all_people_f

306: order by paa.assignment_action_id desc;
307:
308: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
309: select substr(full_name,1,31), substr(national_identifier,1,11)
310: from per_all_people_f
311: where person_id = cp_person_id
312: ORDER BY effective_end_date desc;
313:
314: