APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on HR_ALL_ORGANIZATION_UNITS
Line 5441: HR_ALL_ORGANIZATION_UNITS HAOU
5437: SELECTED_SHIP_TO_LOCATION_ID IS NOT NULL AND
5438: SELECTED_SHIP_TO_LOCATION_ID NOT IN
5439: (SELECT LOC.LOCATION_ID
5440: FROM HR_LOCATIONS_ALL LOC, 5441: HR_ALL_ORGANIZATION_UNITS HAOU 5442: WHERE HAOU.ORGANIZATION_ID = SELECTED_ORG_ID AND
5443: NVL (LOC.BUSINESS_GROUP_ID, NVL(HAOU.BUSINESS_GROUP_ID, -99)) = NVL (HAOU.BUSINESS_GROUP_ID, -99) AND
5444: LOC.SHIP_TO_SITE_FLAG = 'Y' AND
5445: (SELECTED_SHIP_TO_ORG_ID IS NULL OR