View: PAY_CA_WCB_GRP_LEVEL_V

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

View Text

SELECT PWAV.ACCOUNT_NUMBER
, PWAV.PROVINCE
, PWR.RATE_ID
, PWAV.BUSINESS_GROUP_ID
, PWR.CODE
, PWR.RATE
, PWR.DESCRIPTION
, PBS.BALANCE_SET_NAME
, PBS.ATTRIBUTE_1 BASE_BAL_NAME_TAXABLE
, PBS.ATTRIBUTE_2 BASE_BAL_NAME_LIABILITY
, PBS.ATTRIBUTE_3 BASE_BAL_NAME_EXCESS
, PBTTL_1.BALANCE_NAME TL_BAL_NAME_TAXABLE
, PBTTL_2.BALANCE_NAME TL_BAL_NAME_LIABILITY
, PBTTL_3.BALANCE_NAME TL_BAL_NAME_EXCESS
, PBS.ATTRIBUTE_4 DIMENSION
, PBS.LEGISLATION_CODE
, FS.EFFECTIVE_DATE
, PAY_CA_GROUP_LEVEL_BAL_PKG.CA_GROUP_LEVEL_BALANCE( PBS.ATTRIBUTE_1
, 'PYDATE'
, FS.EFFECTIVE_DATE
, ''
, PWR.RATE_ID
, ''
, '' ) PYDATE_TAXABLE
, PAY_CA_GROUP_LEVEL_BAL_PKG.CA_GROUP_LEVEL_BALANCE( PBS.ATTRIBUTE_2
, 'PYDATE'
, FS.EFFECTIVE_DATE
, ''
, PWR.RATE_ID
, ''
, '' ) PYDATE_LIABILITY
, PAY_CA_GROUP_LEVEL_BAL_PKG.CA_GROUP_LEVEL_BALANCE( PBS.ATTRIBUTE_3
, 'PYDATE'
, FS.EFFECTIVE_DATE
, ''
, PWR.RATE_ID
, ''
, '' ) PYDATE_EXCESS
, DECODE(PBS.ATTRIBUTE_4
, NULL
, 0
, PAY_CA_GROUP_LEVEL_BAL_PKG.CA_GROUP_LEVEL_BALANCE( PBS.ATTRIBUTE_1
, PBS.ATTRIBUTE_4
, FS.EFFECTIVE_DATE
, ''
, PWR.RATE_ID
, ''
, '' )) OTD_TAXABLE
, DECODE(PBS.ATTRIBUTE_4
, NULL
, 0
, PAY_CA_GROUP_LEVEL_BAL_PKG.CA_GROUP_LEVEL_BALANCE( PBS.ATTRIBUTE_2
, PBS.ATTRIBUTE_4
, FS.EFFECTIVE_DATE
, ''
, PWR.RATE_ID
, ''
, '' )) OTD_LIABILITY
, DECODE(PBS.ATTRIBUTE_4
, NULL
, 0
, PAY_CA_GROUP_LEVEL_BAL_PKG.CA_GROUP_LEVEL_BALANCE( PBS.ATTRIBUTE_3
, PBS.ATTRIBUTE_4
, FS.EFFECTIVE_DATE
, ''
, PWR.RATE_ID
, ''
, '' )) OTD_EXCESS
FROM PAY_WCI_ACCOUNTS_V PWAV
, PAY_WCI_RATES PWR
, PAY_BALANCE_SETS PBS
, FND_SESSIONS FS
, PAY_BALANCE_TYPES PBT_1
, PAY_BALANCE_TYPES_TL PBTTL_1
, PAY_BALANCE_TYPES PBT_2
, PAY_BALANCE_TYPES_TL PBTTL_2
, PAY_BALANCE_TYPES PBT_3
, PAY_BALANCE_TYPES_TL PBTTL_3
WHERE PWAV.ACCOUNT_ID = PWR.ACCOUNT_ID
AND FS.SESSION_ID = USERENV('SESSIONID')
AND PBS.BALANCE_SET_NAME LIKE 'WCB_SUM%'
AND PBS.LEGISLATION_CODE = 'CA'
AND PBT_1.BALANCE_TYPE_ID = PBTTL_1.BALANCE_TYPE_ID
AND PBS.ATTRIBUTE_1 = PBT_1.BALANCE_NAME
AND PBTTL_1.LANGUAGE = USERENV('LANG')
AND PBT_2.BALANCE_TYPE_ID = PBTTL_2.BALANCE_TYPE_ID
AND PBS.ATTRIBUTE_2 = PBT_2.BALANCE_NAME
AND PBTTL_2.LANGUAGE = USERENV('LANG')
AND PBT_3.BALANCE_TYPE_ID = PBTTL_3.BALANCE_TYPE_ID
AND PBS.ATTRIBUTE_3 = PBT_3.BALANCE_NAME
AND PBTTL_3.LANGUAGE = USERENV('LANG')
AND EXISTS (SELECT 1
FROM PAY_ACTION_CONTEXTS PAC
, FF_CONTEXTS FC
WHERE TO_CHAR(PWR.RATE_ID) = PAC.CONTEXT_VALUE
AND PAC.CONTEXT_ID = FC.CONTEXT_ID
AND FC.CONTEXT_NAME = 'SOURCE_ID')

Columns