[Home] [Help]
201: and l_assign_effective_date < pos.effective_start_date;
202:
203: cursor cur_organizations is
204: select organization_id,name
205: from hr_organization_units
206: where location_id = p_old_location_id
207: for update of location_id;
208:
209: ---cursor cur_loc is
529: loop
530: l_organization_id := cur_organizations_rec.organization_id;
531:
532: ---- Update Organization - New Location
533: update hr_organization_units set location_id = p_new_location_id
534: where current of cur_organizations;
535:
536: l_count := l_count + 1;
537: