1254: ,lv_assignment_status
1255: from per_person_types ppt,
1256: per_people_f ppf,
1257: hr_locations_all hl,
1258: hr_organization_units hou_org,
1259: per_assignment_status_types past,
1260: per_assignments_f paf
1261: where paf.assignment_id = ln_assignment_id
1262: and ld_effective_date between paf.effective_start_date
1281: BEGIN
1282:
1283: select hou_gre.name
1284: into lv_gre_name
1285: from hr_organization_units hou_gre
1286: where hou_gre.organization_id = lv_tax_unit_id;
1287:
1288: EXCEPTION
1289: WHEN NO_DATA_FOUND THEN