APPS.INV_MMX_WRAPPER_PVT dependencies on HR_LOCATIONS

Line 451: FROM HR_ORGANIZATION_UNITS ORG,HR_LOCATIONS LOC

447: -- and using p_organization_id parameter rather than MFG_ORGANIZATION_ID
448: BEGIN
449: SELECT LOC.LOCATION_ID
450: INTO l_dd_loc_id
451: FROM HR_ORGANIZATION_UNITS ORG,HR_LOCATIONS LOC
452: WHERE ORG.ORGANIZATION_ID = nvl(p_organization_id,-1)
453: AND ORG.LOCATION_ID = LOC.LOCATION_ID;
454: EXCEPTION
455: WHEN no_data_found THEN