View: PAY_WC_FUNDS_V

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_WC_FUNDS_V

View Text

SELECT WCF.ROWID
, WCF.FUND_ID
, WCF.BUSINESS_GROUP_ID
, WCF.CARRIER_ID
, ORGTL.NAME
, WCF.LOCATION_ID
, WCF.CALCULATION_METHOD
, WCF.CALCULATION_METHOD2
, WCF.CALCULATION_METHOD3
, LOCTL.LOCATION_CODE
, WCF.STATE_CODE
, PSR.NAME
, WCF.LAST_UPDATE_DATE
, WCF.LAST_UPDATED_BY
, WCF.LAST_UPDATE_LOGIN
, WCF.CREATED_BY
, WCF.CREATION_DATE
FROM PAY_STATE_RULES PSR
, HR_LOCATIONS_NO_JOIN LOC
, HR_LOCATIONS_ALL_TL LOCTL
, HR_ALL_ORGANIZATION_UNITS_TL ORGTL
, HR_ALL_ORGANIZATION_UNITS ORG
, PAY_WC_FUNDS WCF
WHERE LOC.LOCATION_ID = LOCTL.LOCATION_ID (+)
AND DECODE(LOCTL.LOCATION_ID
, NULL
, '1'
, LOCTL.LANGUAGE) = DECODE(LOCTL.LOCATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND ORG.ORGANIZATION_ID = ORGTL.ORGANIZATION_ID
AND ORGTL.LANGUAGE = USERENV('LANG')
AND PSR.STATE_CODE = WCF.STATE_CODE
AND LOC.LOCATION_ID (+) = WCF.LOCATION_ID
AND ORG.ORGANIZATION_ID = WCF.CARRIER_ID

Columns