View: PAY_US_ASG_RUN_ST_LIAB_RBR_V

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

View Text

SELECT PAA.ASSIGNMENT_ID
, PAA.TAX_UNIT_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ACTION_STATUS
, PAA.PAYROLL_ACTION_ID
, PPA.ACTION_TYPE
, PPA.EFFECTIVE_DATE
, STATE.JURISDICTION_CODE
, PETV.TAX_TYPE_ID
, PETV.EE_OR_ER_CODE
, PETV.LIMIT_TAX_FLAG
, PETV.TAX_DOMAIN_CODE
, PETV.TAX_TYPE_CODE
, PETV.BALANCE_CATEGORY_CODE
, PETV.USER_REPORTING_NAME
, PETV.ELEMENT_NAME
, PETV.ELEMENT_TYPE_ID
, PETV.EFFECTIVE_START_DATE
, PETV.EFFECTIVE_END_DATE
, PETV.BUSINESS_GROUP_ID
, PETV.LEGISLATION_CODE
, PETV.PROCESSING_PRIORITY
, NAMES.STATE_ABBREV
, NAMES.STATE_NAME
, PETV.TAX_TYPE_CODE || '-' || NAMES.STATE_ABBREV STATE_TAX_NAME
, 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_TAX_BALANCE_VM (PETV.BALANCE_CATEGORY_CODE
, PETV.TAX_TYPE_CODE
, PETV.EE_OR_ER_CODE
, 'RUN'
, PAA.TAX_UNIT_ID
, STATE.JURISDICTION_CODE
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.DATE_EARNED
, PAA.PAYROLL_ACTION_ID ) RUN_VAL
FROM PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
, PAY_US_STATE_LIABILITY_TYPES_V PETV
, PAY_US_STATES NAMES
, PAY_US_EMP_STATE_TAX_RULES_F STATE
, PAY_RUN_BALANCES PRB
, PAY_BAL_ATTRIBUTE_DEFINITIONS PBAD
, PAY_BALANCE_ATTRIBUTES PBA
, PAY_DEFINED_BALANCES PDB
, PAY_BALANCE_FEEDS_F PBF
, PAY_INPUT_VALUES_F PIV
WHERE STATE.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND NAMES.STATE_CODE = SUBSTR (STATE.JURISDICTION_CODE
, 1
, 2)
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE IN ('Q'
, 'R'
, 'V'
, 'B'
, 'I')
AND NVL (PPA.DATE_EARNED
, PPA.EFFECTIVE_DATE) BETWEEN PETV.EFFECTIVE_START_DATE
AND PETV.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN STATE.EFFECTIVE_START_DATE
AND STATE.EFFECTIVE_END_DATE
AND PAY_US_TAX_INFO_PKG.GET_TAX_EXIST (PETV.TAX_TYPE_CODE
, STATE.JURISDICTION_CODE
, PETV.EE_OR_ER_CODE
, PPA.EFFECTIVE_DATE ) = 'Y'
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
AND PBA.ATTRIBUTE_ID = PBAD.ATTRIBUTE_ID
AND PBAD.ATTRIBUTE_NAME = 'PAY_US_STATE_LIABILITIES'
AND PBAD.BUSINESS_GROUP_ID IS NULL
AND PBAD.LEGISLATION_CODE = 'US'
AND PRB.JURISDICTION_CODE = STATE.STATE_CODE
AND PDB.BALANCE_TYPE_ID = PBF.BALANCE_TYPE_ID
AND PRB.DEFINED_BALANCE_ID = PDB.DEFINED_BALANCE_ID
AND PBF.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PIV.ELEMENT_TYPE_ID = PETV.ELEMENT_TYPE_ID
AND PRB.EFFECTIVE_DATE BETWEEN PBF.EFFECTIVE_START_DATE AND PBF.EFFECTIVE_END_DATE
AND PRB.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE AND PIV.EFFECTIVE_END_DATE

Columns