APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on HZ_LOCATIONS

Line 1486: FROM HZ_LOCATIONS HZL,

1482: nvl(GREATEST(HP.LAST_UPDATE_DATE,HCA.LAST_UPDATE_DATE),
1483: to_date('1900/01/01 00:00:01', 'YYYY/MM/DD HH24:MI:SS')
1484: )
1485: ) LAST_UPDATE_DATE
1486: FROM HZ_LOCATIONS HZL,
1487: WSH_LOCATIONS WL,
1488: FND_TERRITORIES FNDTR,
1489: WSH_OTM_LOCATIONS_GTMP WLT,
1490: HZ_PARTIES HP,

Line 1577: FROM HZ_LOCATIONS HZL,

1573: HZL.LAST_UPDATE_DATE HZL_LAST_UPD_DATE,
1574: WCV.LAST_UPDATE_DATE WCV_LAST_UPD_DATE,
1575: HPS.LAST_UPDATE_DATE HPS_LAST_UPD_DATE,
1576: HP.LAST_UPDATE_DATE HP_LAST_UPD_DATE
1577: FROM HZ_LOCATIONS HZL,
1578: FND_TERRITORIES FNDTR,
1579: WSH_OTM_LOCATIONS_GTMP wlt,
1580: WSH_CARRIERS WCV,
1581: WSH_CARRIER_SITES WCS,