493: AND pbf.effective_end_date));
494:
495: CURSOR c_name(p_org_id number) IS
496: SELECT name
497: FROM hr_all_organization_units_tl
498: WHERE organization_id = p_org_id
499: AND language = userenv('LANG');
500:
501: CURSOR c_person_id(c_assign_id number) IS
544:
545: lv_assn_id per_all_assignments_f.assignment_id%type;
546: lv_result_value number;
547: lv_person_id per_all_people_f.person_id%type;
548: lv_gre_name hr_all_organization_units_tl.name%type;
549: lv_pre_name hr_all_organization_units_tl.name%type;
550: lv_emp_name per_all_people_f.full_name%type;
551: lv_emp_no per_all_people_f.employee_number%type;
552: lv_emp_sin per_all_people_f.national_identifier%type;
545: lv_assn_id per_all_assignments_f.assignment_id%type;
546: lv_result_value number;
547: lv_person_id per_all_people_f.person_id%type;
548: lv_gre_name hr_all_organization_units_tl.name%type;
549: lv_pre_name hr_all_organization_units_tl.name%type;
550: lv_emp_name per_all_people_f.full_name%type;
551: lv_emp_no per_all_people_f.employee_number%type;
552: lv_emp_sin per_all_people_f.national_identifier%type;
553: lv_data_row varchar2(4000);