View: PAY_US_ASG_RUN_DED_RBR_V

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

View Text

SELECT /*+ ORDERED */ DISTINCT PAA.ASSIGNMENT_ID
, PAA.TAX_UNIT_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ACTION_STATUS
, PAA.PAYROLL_ACTION_ID
, PPA.ACTION_TYPE
, PPA.EFFECTIVE_DATE
, PETTL.ELEMENT_NAME
, PETTL.ELEMENT_TYPE_ID
, PET.ELEMENT_INFORMATION10
, PEC.CLASSIFICATION_NAME
, PET.PROCESSING_PRIORITY
, PET.EFFECTIVE_START_DATE
, PET.EFFECTIVE_END_DATE
, PET.BUSINESS_GROUP_ID
, PET.LEGISLATION_CODE
, PETTL.REPORTING_NAME
, NVL (PETTL.REPORTING_NAME
, PETTL.ELEMENT_NAME ) REPORTING_NAME_ALT
, HR_BALANCES.DECODE_BALANCE (PBT.BALANCE_TYPE_ID) BALANCE_NAME
, PBT.BALANCE_TYPE_ID
, PBT.BALANCE_UOM
, PAY_US_BALANCE_VIEW_PKG.GET_VIEW_MODE VIEW_MODE
, PAY_US_BALANCE_VIEW_PKG.GET_CALC_ALL_TIMETYPES_FLAG CALC_ALL_TIMETYPES
, PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER (PBT.BALANCE_NAME)
, 'ASG_GRE_RUN'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.DATE_EARNED
, PAA.TAX_UNIT_ID
, PPA.BUSINESS_GROUP_ID
, NULL ) RUN_VALUE
FROM PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
, PAY_BAL_ATTRIBUTE_DEFINITIONS PBAD
, PAY_BALANCE_ATTRIBUTES PBA
, PAY_RUN_BALANCES PRB
, PAY_DEFINED_BALANCES PDB
, PAY_BALANCE_TYPES PBT
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_TYPES_F_TL PETTL
, PAY_ELEMENT_CLASSIFICATIONS PEC
WHERE PBAD.ATTRIBUTE_NAME IN ('PAY_US_PRE_TAX_DEDUCTIONS'
, 'PAY_US_AFTER_TAX_DEDUCTIONS')
AND PBAD.BUSINESS_GROUP_ID IS NULL
AND PBAD.LEGISLATION_CODE = 'US'
AND PBA.ATTRIBUTE_ID = PBAD.ATTRIBUTE_ID
AND PDB.DEFINED_BALANCE_ID = PBA.DEFINED_BALANCE_ID
AND PDB.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID
AND PDB.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID
AND PET.ELEMENT_INFORMATION10 = PDB.BALANCE_TYPE_ID
AND ( PET.BUSINESS_GROUP_ID + 0 = PPA.BUSINESS_GROUP_ID + 0 OR PET.LEGISLATION_CODE = 'US' )
AND PET.ELEMENT_TYPE_ID = PETTL.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE = USERENV ('LANG')
AND PEC.CLASSIFICATION_ID = PET.CLASSIFICATION_ID
AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND NVL (PPA.DATE_EARNED
, PPA.EFFECTIVE_DATE) BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PRB.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PRB.TAX_UNIT_ID = PAA.TAX_UNIT_ID
AND PRB.DEFINED_BALANCE_ID = PBA.DEFINED_BALANCE_ID

Columns