APPS.PAY_CA_EOY_RL2_AMEND_REG dependencies on PER_PEOPLE_F

Line 269: lv_employee_number per_people_f.employee_number%type;

265: lv_report_type pay_payroll_actions.report_type%TYPE ;
266: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
267:
268: lv_serial_number VARCHAR2(30);
269: lv_employee_number per_people_f.employee_number%type;
270: lv_message varchar2(100):= null;
271: lv_full_name per_people_f.full_name%type;
272: lv_record_name varchar2(100);
273: ln_serial_number pay_assignment_actions.serial_number%TYPE;

Line 271: lv_full_name per_people_f.full_name%type;

267:
268: lv_serial_number VARCHAR2(30);
269: lv_employee_number per_people_f.employee_number%type;
270: lv_message varchar2(100):= null;
271: lv_full_name per_people_f.full_name%type;
272: lv_record_name varchar2(100);
273: ln_serial_number pay_assignment_actions.serial_number%TYPE;
274: lv_ppr_report_type varchar2(50);
275:

Line 426: from per_people_f

422: legislative_parameters) = to_char(cp_pre);
423:
424: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
425: select substr(full_name,1,48), employee_number
426: from per_people_f
427: where person_id = cp_person_id
428: order by effective_end_date desc;
429:
430: CURSOR c_get_prov_amend_flag(cp_asg_act_id number) IS