DBA Data[Home] [Help]

APPS.INV_THIRD_PARTY_STOCK_UTIL dependencies on HR_ALL_ORGANIZATION_UNITS

Line 197: hr_all_organization_units

193: location_id
194: INTO
195: l_location_id
196: FROM
197: hr_all_organization_units
198: WHERE organization_id = p_organization_id;
199:
200: RETURN l_location_id;
201: EXCEPTION -- Bug 6828643 Changes Start

Line 205: FROM hr_all_organization_units haou,

201: EXCEPTION -- Bug 6828643 Changes Start
202: WHEN NO_DATA_FOUND THEN
203: SELECT haou.location_id
204: INTO l_location_id
205: FROM hr_all_organization_units haou,
206: hr_operating_units hou
207: WHERE haou.organization_id = hou.organization_id;
208:
209: RETURN l_location_id; -- Bug 6828643 Changes End