View: PAY_CA_PROVINCES_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_CA_PROVINCES_V

View Text

SELECT FLV.MEANING
, CO.COUNTY_CODE
, CO.COUNTY_ABBREV
FROM PAY_US_COUNTIES CO
, FND_LOOKUP_VALUES FLV
WHERE CO.STATE_CODE = '70'
AND FLV.LOOKUP_TYPE = 'CA_PROVINCE'
AND FLV.LOOKUP_CODE = CO.COUNTY_ABBREV
AND FLV.LANGUAGE = USERENV('LANG')
AND FLV.ENABLED_FLAG = 'Y'

Columns