DBA Data[Home] [Help]

APPS.CSI_ML_UTIL_PVT dependencies on HR_OPERATING_UNITS

Line 231: FROM hr_operating_units

227:
228: FORALL i16 in 1 .. inst_intf_id_upd.count
229: UPDATE csi_instance_interface a
230: SET a.operating_unit=(SELECT organization_id
231: FROM hr_operating_units
232: WHERE name = a.operating_unit_name)
233: WHERE inst_interface_id=inst_intf_id_upd(i16)
234: AND a.operating_unit IS NULL
235: AND a.operating_unit_name IS NOT NULL;

Line 758: FROM hr_operating_units

754:
755: FORALL i16 in 1 .. inst_intf_id_upd.count
756: UPDATE csi_instance_interface a
757: SET a.operating_unit=(SELECT organization_id
758: FROM hr_operating_units
759: WHERE name = a.operating_unit_name)
760: WHERE inst_interface_id=inst_intf_id_upd(i16)
761: AND a.operating_unit IS NULL
762: AND a.operating_unit_name IS NOT NULL;