View: HXC_TK_PAY_LOCATIONS

Product:	HXC - Time and Labor Engine
Description:	Lists the work locations
Implementation/DBA Data:	APPS.HXC_TK_PAY_LOCATIONS

View Text

SELECT PCY.CITY_NAME||'
, '||PST.STATE_NAME||'
, '||PCT.COUNTY_NAME||' COUNTY
, '||PZC.ZIP_START
, PST.STATE_ABBREV
, PST.STATE_NAME
, PCT.COUNTY_NAME
, PCY.CITY_NAME
, PZC.ZIP_START
, PZC.ZIP_END
FROM PAY_US_STATES PST
, PAY_US_COUNTIES PCT
, PAY_US_CITY_NAMES PCY
, PAY_US_ZIP_CODES PZC
WHERE PCY.STATE_CODE = PST.STATE_CODE
AND PCY.COUNTY_CODE = PCT.COUNTY_CODE
AND PCT.STATE_CODE = PST.STATE_CODE
AND PCY.CITY_CODE = PZC.CITY_CODE
AND PCY.STATE_CODE = PZC.STATE_CODE
AND PCY.COUNTY_CODE = PZC.COUNTY_CODE
AND (PST.STATE_CODE<52 OR PST.STATE_CODE=72) ORDER BY PCY.CITY_NAME
, PST.STATE_NAME
, PCT.COUNTY_NAME
, PZC.ZIP_START

Columns