View: PAY_SG_BALANCES_MATRIX_V

Product:	PAY - Payroll
Description:	Singapore localisation view.
Implementation/DBA Data:	APPS.PAY_SG_BALANCES_MATRIX_V

View Text

SELECT PAA.ASSIGNMENT_ACTION_ID
, PAA.ACTION_SEQUENCE
, PBTTL.BALANCE_NAME
, PBT.BALANCE_TYPE_ID
, PAA.TAX_UNIT_ID
, PAA.ASSIGNMENT_ID
, SUM(DECODE(PBD.DATABASE_ITEM_SUFFIX
, '_ASG_LE_RUN'
, PAY_BALANCE_PKG.GET_VALUE(PDB.DEFINED_BALANCE_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.TAX_UNIT_ID
, NULL
, NULL
, NULL
, NULL )
, 0)) ASG_LE_RUN_BAL
, SUM(DECODE(PBD.DATABASE_ITEM_SUFFIX
, '_ASG_LE_PTD'
, PAY_BALANCE_PKG.GET_VALUE(PDB.DEFINED_BALANCE_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.TAX_UNIT_ID
, NULL
, NULL
, NULL
, NULL )
, 0)) ASG_LE_PTD_BAL
, SUM(DECODE(PBD.DATABASE_ITEM_SUFFIX
, '_ASG_LE_MONTH'
, PAY_BALANCE_PKG.GET_VALUE(PDB.DEFINED_BALANCE_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.TAX_UNIT_ID
, NULL
, NULL
, NULL
, NULL )
, 0)) ASG_LE_MTD_BAL
, SUM(DECODE(PBD.DATABASE_ITEM_SUFFIX
, '_ASG_LE_QTD'
, PAY_BALANCE_PKG.GET_VALUE(PDB.DEFINED_BALANCE_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.TAX_UNIT_ID
, NULL
, NULL
, NULL
, NULL )
, 0)) ASG_LE_QTD_BAL
, SUM(DECODE(PBD.DATABASE_ITEM_SUFFIX
, '_ASG_LE_YTD'
, PAY_BALANCE_PKG.GET_VALUE(PDB.DEFINED_BALANCE_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.TAX_UNIT_ID
, NULL
, NULL
, NULL
, NULL )
, 0)) ASG_LE_YTD_BAL
, SUM(DECODE(PBD.DATABASE_ITEM_SUFFIX
, '_ASG_LE_FQTD'
, PAY_BALANCE_PKG.GET_VALUE(PDB.DEFINED_BALANCE_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.TAX_UNIT_ID
, NULL
, NULL
, NULL
, NULL )
, 0)) ASG_LE_FQTD_BAL
, SUM(DECODE(PBD.DATABASE_ITEM_SUFFIX
, '_ASG_LE_FYTD'
, PAY_BALANCE_PKG.GET_VALUE(PDB.DEFINED_BALANCE_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.TAX_UNIT_ID
, NULL
, NULL
, NULL
, NULL )
, 0)) ASG_LE_FYTD_BAL
, SUM(DECODE(PBD.DATABASE_ITEM_SUFFIX
, '_ASG_LE_LTD'
, PAY_BALANCE_PKG.GET_VALUE(PDB.DEFINED_BALANCE_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.TAX_UNIT_ID
, NULL
, NULL
, NULL
, NULL )
, 0)) ASG_LE_LTD_BAL
FROM PAY_BALANCE_TYPES PBT
, PAY_BALANCE_TYPES_TL PBTTL
, PAY_BALANCE_DIMENSIONS PBD
, PAY_DEFINED_BALANCES PDB
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
WHERE ((PBT.LEGISLATION_CODE IS NULL
AND PBT.BUSINESS_GROUP_ID = PPA.BUSINESS_GROUP_ID) OR PBT.LEGISLATION_CODE = 'SG')
AND PBT.BALANCE_TYPE_ID = PBTTL.BALANCE_TYPE_ID
AND PBTTL.LANGUAGE = USERENV('LANG')
AND PDB.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID
AND PDB.BALANCE_DIMENSION_ID = PBD.BALANCE_DIMENSION_ID
AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND EXISTS (SELECT ' '
FROM PAY_ASSIGNMENT_ACTIONS PAA2
, PAY_BALANCE_FEEDS_F FEED
, PAY_RUN_RESULT_VALUES PRRV
, PAY_RUN_RESULTS PRR
WHERE PBT.BALANCE_TYPE_ID = FEED.BALANCE_TYPE_ID
AND PRR.RUN_RESULT_ID = PRRV.RUN_RESULT_ID
AND FEED.INPUT_VALUE_ID = PRRV.INPUT_VALUE_ID
AND PRRV.RESULT_VALUE IS NOT NULL
AND PRRV.RESULT_VALUE <> '0'
AND PAA2.ACTION_SEQUENCE <= PAA.ACTION_SEQUENCE
AND PAA2.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID
AND PAA2.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID ) GROUP BY PAA.ASSIGNMENT_ACTION_ID
, PAA.ACTION_SEQUENCE
, PBTTL.BALANCE_NAME
, PBT.BALANCE_TYPE_ID
, PAA.TAX_UNIT_ID
, PAA.ASSIGNMENT_ID

Columns