DBA Data[Home] [Help]

APPS.POS_SUPPLIER_ADDRESS_PKG dependencies on HR_OPERATING_UNITS

Line 279: FROM hr_operating_units o

275: end;
276: END IF;
277:
278: FOR x IN (SELECT name
279: FROM hr_operating_units o
280: WHERE mo_global.check_access(organization_id) = 'Y'
281: AND o.organization_id = nvl(l_reg_ou_id,o.organization_id)
282: AND NOT exists
283: (SELECT 1