VIEW: APPS.PAY_WC_FUNDS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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