View: PAY_CA_PMED_WCB_BALANCES_V

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

View Text

SELECT PAA.ASSIGNMENT_ID
, PAA.TAX_UNIT_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ACTION_STATUS
, PPA.PAYROLL_ACTION_ID
, PPA.ACTION_TYPE
, PPA.EFFECTIVE_DATE
, PBS.ATTRIBUTE_1
, PBTTL.BALANCE_NAME
, PBTTL.REPORTING_NAME
, PPA.BUSINESS_GROUP_ID
, PBS.LEGISLATION_CODE
, PWI.BALANCE_TYPE
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE( PBS.ATTRIBUTE_1
, 'CURRENT'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
, PAA.TAX_UNIT_ID
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('BUSINESS_GROUP')
, NULL
, PWI.SOURCE_ID ) CURRENT_VALUE
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE( PBS.ATTRIBUTE_1
, 'RUN'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
, PAA.TAX_UNIT_ID
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('BUSINESS_GROUP')
, NULL
, PWI.SOURCE_ID )RUN_VALUE
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE( PBS.ATTRIBUTE_1
, 'PYDATE'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
, PAA.TAX_UNIT_ID
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('BUSINESS_GROUP')
, NULL
, PWI.SOURCE_ID )PYDATE_VALUE
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE( PBS.ATTRIBUTE_1
, 'MONTH'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
, PAA.TAX_UNIT_ID
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('BUSINESS_GROUP')
, NULL
, PWI.SOURCE_ID )MONTH_VALUE
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE( PBS.ATTRIBUTE_1
, 'QTD'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
, PAA.TAX_UNIT_ID
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('BUSINESS_GROUP')
, NULL
, PWI.SOURCE_ID )QTD_VALUE
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE( PBS.ATTRIBUTE_1
, 'PTD'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
, PAA.TAX_UNIT_ID
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('BUSINESS_GROUP')
, NULL
, PWI.SOURCE_ID )PTD_VALUE
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE( PBS.ATTRIBUTE_1
, 'YTD'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
, PAA.TAX_UNIT_ID
, PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('BUSINESS_GROUP')
, NULL
, PWI.SOURCE_ID )YTD_VALUE
FROM PAY_CA_PMED_WCB_ID_V PWI
, PAY_BALANCE_SETS PBS
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_BALANCE_TYPES PBT
, PAY_BALANCE_TYPES_TL PBTTL
WHERE PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE IN ('Q'
, 'R'
, 'V'
, 'B'
, 'I')
AND PPA.ACTION_STATUS = 'C'
AND PBS.ATTRIBUTE_1 = PBT.BALANCE_NAME
AND PBT.LEGISLATION_CODE = 'CA'
AND PBT.BALANCE_TYPE_ID = PBTTL.BALANCE_TYPE_ID
AND PBTTL.LANGUAGE = USERENV('LANG')
AND PWI.BALANCE_TYPE = DECODE(PBS.BALANCE_SET_NAME
, 'WCB'
, 'WCB'
, 'PMED'
, 'PMED')
AND PPA.BUSINESS_GROUP_ID = PWI.BUSINESS_GROUP_ID + 0
AND PBS.LEGISLATION_CODE = 'CA'
AND EXISTS ( SELECT 'X'
FROM PAY_PAYROLL_ACTIONS PPA2
, PAY_ASSIGNMENT_ACTIONS PAA2
, PAY_ACTION_CONTEXTS PAC2
, FF_CONTEXTS FFC2
WHERE PAA2.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PAC2.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PPA2.PAYROLL_ACTION_ID = PAA2.PAYROLL_ACTION_ID
AND PPA2.EFFECTIVE_DATE BETWEEN TRUNC(PPA.EFFECTIVE_DATE
, 'YEAR')
AND PPA.EFFECTIVE_DATE
AND PPA2.ACTION_TYPE IN ('R'
, 'Q')
AND PAC2.CONTEXT_VALUE =TO_CHAR( PWI.SOURCE_ID)
AND PAC2.CONTEXT_ID = FFC2.CONTEXT_ID
AND FFC2.CONTEXT_NAME = 'SOURCE_ID')

Columns