APPS.INV_MMX_WRAPPER_PVT dependencies on HR_LOCATIONS

Line 447: FROM HR_ORGANIZATION_UNITS ORG,HR_LOCATIONS LOC

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