136: FORALL i2 in 1 .. inst_intf_id_upd.count
137: UPDATE csi_instance_interface a
138: SET a.inv_vld_organization_id =
139: (SELECT organization_id
140: FROM hr_all_organization_units
141: WHERE name = a.inv_vld_organization_name)
142: WHERE inst_interface_id=inst_intf_id_upd(i2)
143: AND a.inv_vld_organization_id IS NULL
144: AND a.inv_vld_organization_name IS NOT NULL;
186: FORALL i8 in 1 .. inst_intf_id_upd.count
187: UPDATE csi_instance_interface a
188: SET a.inv_organization_id =
189: (SELECT organization_id
190: FROM hr_all_organization_units
191: WHERE NAME = a.inv_organization_name)
192: WHERE inst_interface_id=inst_intf_id_upd(i8)
193: AND a.inv_organization_id IS NULL
194: AND a.inv_organization_name IS NOT NULL;
451: FORALL i2 in 1 .. iea_intf_id_upd.count
452: UPDATE csi_iea_value_interface a
453: SET a.master_organization_id =
454: (SELECT organization_id
455: FROM hr_all_organization_units
456: WHERE name = master_organization_name)
457: WHERE ieav_interface_id=iea_intf_id_upd(i2)
458: AND a.master_organization_id IS NULL
459: AND master_organization_name IS NOT NULL;
665: FORALL i2 in 1 .. inst_intf_id_upd.count
666: UPDATE csi_instance_interface a
667: SET a.inv_vld_organization_id =
668: (SELECT organization_id
669: FROM hr_all_organization_units
670: WHERE name = a.inv_vld_organization_name)
671: WHERE inst_interface_id=inst_intf_id_upd(i2)
672: AND a.inv_vld_organization_id IS NULL
673: AND a.inv_vld_organization_name IS NOT NULL;
714: FORALL i8 in 1 .. inst_intf_id_upd.count
715: UPDATE csi_instance_interface a
716: SET a.inv_organization_id =
717: (SELECT organization_id
718: FROM hr_all_organization_units
719: WHERE NAME = a.inv_organization_name)
720: WHERE inst_interface_id=inst_intf_id_upd(i8)
721: AND a.inv_organization_id IS NULL
722: AND a.inv_organization_name IS NOT NULL;
974: FORALL i2 in 1 .. iea_intf_id_upd.count
975: UPDATE csi_iea_value_interface a
976: SET a.master_organization_id =
977: (SELECT organization_id
978: FROM hr_all_organization_units
979: WHERE name = master_organization_name)
980: WHERE ieav_interface_id=iea_intf_id_upd(i2)
981: AND a.master_organization_id IS NULL
982: AND a.master_organization_name IS NOT NULL;