APPS.PAY_US_YEPP_ADD_ACTIONS_PKG dependencies on PER_PEOPLE_F

Line 423: from per_people_f

419: -- Cursor to get Employee details
420: cursor c_employee_details (cp_person_id number )
421: is
422: select employee_number,full_name,national_identifier
423: from per_people_f
424: where person_id = cp_person_id;
425:
426: lv_result_value number:=0;
427: lv_person_id per_all_people_f.person_id%type;

Line 430: lv_emp_name per_people_f.full_name%type;

426: lv_result_value number:=0;
427: lv_person_id per_all_people_f.person_id%type;
428: lv_gre_name hr_organization_units.name%type;
429: lv_gre_type varchar2(10);
430: lv_emp_name per_people_f.full_name%type;
431: lv_emp_no per_people_f.employee_number%type;
432: lv_emp_ssn per_people_f.national_identifier%type;
433: lv_data_row varchar2(4000);
434: l_assignment_inserted number :=0;

Line 431: lv_emp_no per_people_f.employee_number%type;

427: lv_person_id per_all_people_f.person_id%type;
428: lv_gre_name hr_organization_units.name%type;
429: lv_gre_type varchar2(10);
430: lv_emp_name per_people_f.full_name%type;
431: lv_emp_no per_people_f.employee_number%type;
432: lv_emp_ssn per_people_f.national_identifier%type;
433: lv_data_row varchar2(4000);
434: l_assignment_inserted number :=0;
435: l_effective_date date;

Line 432: lv_emp_ssn per_people_f.national_identifier%type;

428: lv_gre_name hr_organization_units.name%type;
429: lv_gre_type varchar2(10);
430: lv_emp_name per_people_f.full_name%type;
431: lv_emp_no per_people_f.employee_number%type;
432: lv_emp_ssn per_people_f.national_identifier%type;
433: lv_data_row varchar2(4000);
434: l_assignment_inserted number :=0;
435: l_effective_date date;
436: l_temp number;