APPS.PAY_US_YEPP_MISS_ASSIGN_PKG dependencies on PER_PEOPLE_F

Line 369: FROM per_people_f

365:
366: CURSOR c_employee_details ( c_person_id number )
367: IS
368: SELECT employee_number,full_name,national_identifier
369: FROM per_people_f
370: WHERE person_id = c_person_id;
371:
372: CURSOR c_assignment_set_id
373: IS

Line 457: lv_person_id per_people_f.person_id%type;

453: )
454: );
455:
456: lv_result_value number:=0;
457: lv_person_id per_people_f.person_id%type;
458: lv_gre_name hr_organization_units.name%type;
459: lv_emp_name per_people_f.full_name%type;
460: lv_emp_no per_people_f.employee_number%type;
461: lv_emp_ssn per_people_f.national_identifier%type;

Line 459: lv_emp_name per_people_f.full_name%type;

455:
456: lv_result_value number:=0;
457: lv_person_id per_people_f.person_id%type;
458: lv_gre_name hr_organization_units.name%type;
459: lv_emp_name per_people_f.full_name%type;
460: lv_emp_no per_people_f.employee_number%type;
461: lv_emp_ssn per_people_f.national_identifier%type;
462: lv_data_row VARCHAR2(4000);
463: row_id VARCHAR2(100);

Line 460: lv_emp_no per_people_f.employee_number%type;

456: lv_result_value number:=0;
457: lv_person_id per_people_f.person_id%type;
458: lv_gre_name hr_organization_units.name%type;
459: lv_emp_name per_people_f.full_name%type;
460: lv_emp_no per_people_f.employee_number%type;
461: lv_emp_ssn per_people_f.national_identifier%type;
462: lv_data_row VARCHAR2(4000);
463: row_id VARCHAR2(100);
464: lv_miss_assignments NUMBER :=0;

Line 461: lv_emp_ssn per_people_f.national_identifier%type;

457: lv_person_id per_people_f.person_id%type;
458: lv_gre_name hr_organization_units.name%type;
459: lv_emp_name per_people_f.full_name%type;
460: lv_emp_no per_people_f.employee_number%type;
461: lv_emp_ssn per_people_f.national_identifier%type;
462: lv_data_row VARCHAR2(4000);
463: row_id VARCHAR2(100);
464: lv_miss_assignments NUMBER :=0;
465: lv_effective_date date;