DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 4592: HR_ALL_ORGANIZATION_UNITS HAOU

4588: SELECTED_SHIP_TO_LOCATION_ID IS NOT NULL AND
4589: SELECTED_SHIP_TO_LOCATION_ID NOT IN
4590: (SELECT LOC.LOCATION_ID
4591: FROM HR_LOCATIONS_ALL LOC,
4592: HR_ALL_ORGANIZATION_UNITS HAOU
4593: WHERE HAOU.ORGANIZATION_ID = SELECTED_ORG_ID AND
4594: NVL (LOC.BUSINESS_GROUP_ID, NVL(HAOU.BUSINESS_GROUP_ID, -99)) = NVL (HAOU.BUSINESS_GROUP_ID, -99) AND
4595: LOC.SHIP_TO_SITE_FLAG = 'Y' AND
4596: (SELECTED_SHIP_TO_ORG_ID IS NULL OR