View: PAY_CA_SOE_SUMM_BALANCES_V

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

View Text

SELECT PAA.ASSIGNMENT_ACTION_ID
, PAA.TAX_UNIT_ID
, PAA.ASSIGNMENT_ID
, HR_BALANCES.DECODE_BALANCE(PBT.BALANCE_TYPE_ID)
, DECODE(PBT.BALANCE_NAME
, 'INVOLUNTARY DEDUCTIONS'
, PYCADAR_PKG.GET_LABELS('CA_ELEMENT_GROUP'
, 'OTHDED'
, PBTTL.LANGUAGE)
, 'VOLUNTARY DEDUCTIONS'
, PYCADAR_PKG.GET_LABELS('CA_ELEMENT_GROUP'
, 'OTHDED'
, PBTTL.LANGUAGE)
, PBTTL.REPORTING_NAME)
, PPA.ACTION_TYPE
, DECODE(PPA.ACTION_TYPE
, 'R'
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE ( PBT.BALANCE_NAME
, 'RUN'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, NULL
, 'ASG'
, PAA.TAX_UNIT_ID
, PBT.BUSINESS_GROUP_ID
, NULL )
, 'Q'
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE ( PBT.BALANCE_NAME
, 'RUN'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, NULL
, 'ASG'
, PAA.TAX_UNIT_ID
, PBT.BUSINESS_GROUP_ID
, NULL )
, 'V'
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE ( PBT.BALANCE_NAME
, 'RUN'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, NULL
, 'ASG'
, PAA.TAX_UNIT_ID
, PBT.BUSINESS_GROUP_ID
, NULL )
, 'U'
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE ( PBT.BALANCE_NAME
, 'CURRENT'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, NULL
, 'ASG'
, PAA.TAX_UNIT_ID
, PBT.BUSINESS_GROUP_ID
, NULL )
, 'P'
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE ( PBT.BALANCE_NAME
, 'CURRENT'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, NULL
, 'ASG'
, PAA.TAX_UNIT_ID
, PBT.BUSINESS_GROUP_ID
, NULL )) AMOUNT_RUN
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE ( PBT.BALANCE_NAME
, 'CURRENT'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, NULL
, 'ASG'
, PAA.TAX_UNIT_ID
, PBT.BUSINESS_GROUP_ID
, NULL )
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE ( PBT.BALANCE_NAME
, 'QTD'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, NULL
, 'ASG'
, PAA.TAX_UNIT_ID
, PBT.BUSINESS_GROUP_ID
, NULL )
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE ( PBT.BALANCE_NAME
, 'PTD'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, NULL
, 'ASG'
, PAA.TAX_UNIT_ID
, PBT.BUSINESS_GROUP_ID
, NULL )
, PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE ( PBT.BALANCE_NAME
, 'YTD'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, NULL
, 'ASG'
, PAA.TAX_UNIT_ID
, PBT.BUSINESS_GROUP_ID
, NULL ) AMOUNT_YTD
, DECODE( PBT.BALANCE_NAME
, 'GROSS EARNINGS'
, 1
, 'GROSS PAY'
, 2
, 'PRE TAX DEDUCTIONS'
, 3
, 'TAX DEDUCTIONS'
, 4
, 'INVOLUNTARY DEDUCTIONS'
, 5
, 'VOLUNTARY DEDUCTIONS'
, 5
, 'PAYMENTS'
, 6
, 'TAXABLE BENEFITS'
, 7)
, PBT.BALANCE_NAME BASE_BAL_NAME
FROM PAY_BALANCE_TYPES PBT
, PAY_BALANCE_TYPES_TL PBTTL
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE IN ('Q'
, 'R'
, 'V'
, 'B'
, 'I')
AND PBT.LEGISLATION_CODE = 'CA'
AND PBT.BALANCE_TYPE_ID = PBTTL.BALANCE_TYPE_ID
AND PBTTL.LANGUAGE = USERENV('LANG')
AND PBT.BALANCE_NAME IN ('GROSS EARNINGS'
, 'GROSS PAY'
, 'PRE TAX DEDUCTIONS'
, 'TAX DEDUCTIONS'
, 'INVOLUNTARY DEDUCTIONS'
, 'VOLUNTARY DEDUCTIONS'
, 'PAYMENTS'
, 'TAXABLE BENEFITS')

Columns