APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 88: FROM HR_ALL_ORGANIZATION_UNITS HOU,

84: ) RETURN NUMBER
85: IS
86: cursor l_stop_dd_org_csr(p_stop_id IN NUMBER) is
87: SELECT HOU.ORGANIZATION_ID
88: FROM HR_ALL_ORGANIZATION_UNITS HOU,
89: WSH_LOCATIONS WL,
90: WSH_NEW_DELIVERIES WND,
91: WSH_DELIVERY_LEGS WDL,
92: WSH_TRIP_STOPS WTS

Line 1408: HR_ALL_ORGANIZATION_UNITS ORG,

1404: GREATEST(HRL.LAST_UPDATE_DATE,
1405: nvl(ORG.LAST_UPDATE_DATE, to_date('1900/01/01 00:00:01', 'YYYY/MM/DD HH24:MI:SS'))
1406: ) LAST_UPDATE_DATE
1407: from HR_LOCATIONS_ALL HRL,
1408: HR_ALL_ORGANIZATION_UNITS ORG,
1409: --HR_ALL_ORGANIZATION_UNITS_TL ORGL,
1410: --FND_LANGUAGES FNDL,
1411: FND_TERRITORIES FNDTR,
1412: WSH_OTM_LOCATIONS_GTMP WLT, -- global temp table

Line 1409: --HR_ALL_ORGANIZATION_UNITS_TL ORGL,

1405: nvl(ORG.LAST_UPDATE_DATE, to_date('1900/01/01 00:00:01', 'YYYY/MM/DD HH24:MI:SS'))
1406: ) LAST_UPDATE_DATE
1407: from HR_LOCATIONS_ALL HRL,
1408: HR_ALL_ORGANIZATION_UNITS ORG,
1409: --HR_ALL_ORGANIZATION_UNITS_TL ORGL,
1410: --FND_LANGUAGES FNDL,
1411: FND_TERRITORIES FNDTR,
1412: WSH_OTM_LOCATIONS_GTMP WLT, -- global temp table
1413: MTL_PARAMETERS MP,