APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on HZ_LOCATIONS

Line 1447: FROM HZ_LOCATIONS HZL,

1443: nvl(GREATEST(HP.LAST_UPDATE_DATE,HCA.LAST_UPDATE_DATE),
1444: to_date('1900/01/01 00:00:01', 'YYYY/MM/DD HH24:MI:SS')
1445: )
1446: ) LAST_UPDATE_DATE
1447: FROM HZ_LOCATIONS HZL,
1448: WSH_LOCATIONS WL,
1449: FND_TERRITORIES FNDTR,
1450: WSH_OTM_LOCATIONS_GTMP WLT,
1451: HZ_PARTIES HP,

Line 1538: FROM HZ_LOCATIONS HZL,

1534: HZL.LAST_UPDATE_DATE HZL_LAST_UPD_DATE,
1535: WCV.LAST_UPDATE_DATE WCV_LAST_UPD_DATE,
1536: HPS.LAST_UPDATE_DATE HPS_LAST_UPD_DATE,
1537: HP.LAST_UPDATE_DATE HP_LAST_UPD_DATE
1538: FROM HZ_LOCATIONS HZL,
1539: FND_TERRITORIES FNDTR,
1540: WSH_OTM_LOCATIONS_GTMP wlt,
1541: WSH_CARRIERS WCV,
1542: WSH_CARRIER_SITES WCS,