APPS.PAY_YEPP_MISS_ASSIGN_PKG dependencies on PER_PEOPLE_F

Line 381: FROM per_people_f

377:
378: CURSOR c_employee_details ( c_person_id number )
379: IS
380: SELECT employee_number,full_name,national_identifier
381: FROM per_people_f
382: WHERE person_id = c_person_id;
383:
384: CURSOR c_assignment_set_id
385: IS

Line 468: lv_person_id per_people_f.person_id%type;

464: )
465: );
466:
467: lv_result_value number:=0;
468: lv_person_id per_people_f.person_id%type;
469: lv_gre_or_pre_name hr_organization_units.name%type;
470: lv_emp_name per_people_f.full_name%type;
471: lv_emp_no per_people_f.employee_number%type;
472: lv_emp_ssn per_people_f.national_identifier%type;

Line 470: lv_emp_name per_people_f.full_name%type;

466:
467: lv_result_value number:=0;
468: lv_person_id per_people_f.person_id%type;
469: lv_gre_or_pre_name hr_organization_units.name%type;
470: lv_emp_name per_people_f.full_name%type;
471: lv_emp_no per_people_f.employee_number%type;
472: lv_emp_ssn per_people_f.national_identifier%type;
473: lv_data_row VARCHAR2(4000);
474: row_id VARCHAR2(100);

Line 471: lv_emp_no per_people_f.employee_number%type;

467: lv_result_value number:=0;
468: lv_person_id per_people_f.person_id%type;
469: lv_gre_or_pre_name hr_organization_units.name%type;
470: lv_emp_name per_people_f.full_name%type;
471: lv_emp_no per_people_f.employee_number%type;
472: lv_emp_ssn per_people_f.national_identifier%type;
473: lv_data_row VARCHAR2(4000);
474: row_id VARCHAR2(100);
475: lv_miss_assignments NUMBER :=0;

Line 472: lv_emp_ssn per_people_f.national_identifier%type;

468: lv_person_id per_people_f.person_id%type;
469: lv_gre_or_pre_name hr_organization_units.name%type;
470: lv_emp_name per_people_f.full_name%type;
471: lv_emp_no per_people_f.employee_number%type;
472: lv_emp_ssn per_people_f.national_identifier%type;
473: lv_data_row VARCHAR2(4000);
474: row_id VARCHAR2(100);
475: lv_miss_assignments NUMBER :=0;
476: lv_effective_date date;