View: PAY_US_GTN_DEDUCT_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_US_GTN_DEDUCT_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
, DEDUCT.ELEMENT_NAME
, DEDUCT.ELEMENT_TYPE_ID
, DEDUCT.CLASSIFICATION_NAME
, DEDUCT.BUSINESS_GROUP_ID
, DEDUCT.EFFECTIVE_START_DATE
, DEDUCT.EFFECTIVE_END_DATE
, DEDUCT.LEGISLATION_CODE
, DEDUCT.ELEMENT_INFORMATION10
, DEDUCT.PROCESSING_PRIORITY
, DEDUCT.REPORTING_NAME
, DEDUCT.REPORTING_NAME_ALT
, PBT.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
, DEDUCT.BUSINESS_GROUP_ID
, NULL) RUN_VALUE
FROM PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
, PAY_BALANCE_TYPES PBT
, PAY_US_DEDUCTION_TYPES_V DEDUCT
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND DEDUCT.ELEMENT_INFORMATION10 IS NOT NULL
AND DEDUCT.ELEMENT_INFORMATION10 = PBT.BALANCE_TYPE_ID
AND PPA.ACTION_TYPE IN('Q'
, 'R'
, 'V')
AND NVL(PPA.DATE_EARNED
, PPA.EFFECTIVE_DATE) BETWEEN DEDUCT.EFFECTIVE_START_DATE
AND DEDUCT.EFFECTIVE_END_DATE
AND EXISTS( SELECT NULL
FROM PAY_RUN_RESULTS PRR
WHERE PRR.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PRR.ELEMENT_TYPE_ID = DEDUCT.ELEMENT_TYPE_ID)

Columns