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
532:
533: CURSOR c_all_gres(cp_pre_id number) IS
534: SELECT hoi.organization_id gre_id
535: FROM hr_organization_information hoi,
536: hr_all_organization_units hou
537: WHERE hoi.org_information_context = 'Canada Employer Identification'
538: AND hoi.org_information2 = to_char(cp_pre_id)
539: AND hou.business_group_id = p_bus_grp
540: AND hou.organization_id = hoi.organization_id;
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);