468: -- Cursor to get Employee details
469:
470: cursor c_employee_details (cp_person_id number ) is
471: select full_name,national_identifier
472: from per_all_people_f
473: where person_id = cp_person_id;
474:
475: cursor c_assignment_no (cp_assign_id number ) is
476: select assignment_number
476: select assignment_number
477: from per_all_assignments_f
478: where assignment_id = cp_assign_id;
479:
480: lv_person_id per_all_people_f.person_id%type;
481: lv_gre_name hr_all_organization_units_tl.name%type;
482: lv_pre_name hr_all_organization_units_tl.name%type;
483: lv_emp_name per_all_people_f.full_name%type;
484: lv_emp_no per_all_people_f.employee_number%type;
479:
480: lv_person_id per_all_people_f.person_id%type;
481: lv_gre_name hr_all_organization_units_tl.name%type;
482: lv_pre_name hr_all_organization_units_tl.name%type;
483: lv_emp_name per_all_people_f.full_name%type;
484: lv_emp_no per_all_people_f.employee_number%type;
485: lv_emp_sin per_all_people_f.national_identifier%type;
486: lv_data_row varchar2(4000);
487: l_assignment_inserted number :=0;
480: lv_person_id per_all_people_f.person_id%type;
481: lv_gre_name hr_all_organization_units_tl.name%type;
482: lv_pre_name hr_all_organization_units_tl.name%type;
483: lv_emp_name per_all_people_f.full_name%type;
484: lv_emp_no per_all_people_f.employee_number%type;
485: lv_emp_sin per_all_people_f.national_identifier%type;
486: lv_data_row varchar2(4000);
487: l_assignment_inserted number :=0;
488: l_effective_date date;
481: lv_gre_name hr_all_organization_units_tl.name%type;
482: lv_pre_name hr_all_organization_units_tl.name%type;
483: lv_emp_name per_all_people_f.full_name%type;
484: lv_emp_no per_all_people_f.employee_number%type;
485: lv_emp_sin per_all_people_f.national_identifier%type;
486: lv_data_row varchar2(4000);
487: l_assignment_inserted number :=0;
488: l_effective_date date;
489: l_temp number;
819: cp_effective_date date) is
820: select paa.assignment_action_id
821: from pay_assignment_actions paa,
822: per_all_assignments_f paf,
823: per_all_people_f ppf,
824: pay_payroll_actions ppa,
825: pay_action_classifications pac
826: where ppf.person_id = cp_person_id
827: and paf.person_id = ppf.person_id