View: PAY_US_GTN_EARNINGS_V

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

View Text

SELECT PAA.TAX_UNIT_ID
, PAA.ASSIGNMENT_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ACTION_STATUS
, PAA.PAYROLL_ACTION_ID
, PPA.ACTION_TYPE
, PPA.EFFECTIVE_DATE
, ERNV.ELEMENT_NAME
, ERNV.ELEMENT_TYPE_ID
, ERNV.CLASSIFICATION_NAME
, PET.PROCESSING_PRIORITY
, PET.EFFECTIVE_START_DATE
, PET.EFFECTIVE_END_DATE
, PET.BUSINESS_GROUP_ID
, PET.LEGISLATION_CODE
, PET.REPORTING_NAME
, NVL(PET.REPORTING_NAME
, PET.ELEMENT_NAME) 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
, PET.BUSINESS_GROUP_ID
, NULL) CASH_VALUE
, PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM( UPPER(PBT2.BALANCE_NAME)
, 'ASG_GRE_RUN'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.DATE_EARNED
, PAA.TAX_UNIT_ID
, PET.BUSINESS_GROUP_ID
, NULL) HOURS_VALUE
FROM PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
, PAY_ELEMENT_TYPES_F PET
, PAY_BALANCE_TYPES PBT
, PAY_BALANCE_TYPES PBT2
, PAY_US_EARNINGS_TYPES_V ERNV
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE IN('Q'
, 'R'
, 'V')
AND PET.ELEMENT_TYPE_ID = ERNV.ELEMENT_TYPE_ID
AND PET.ELEMENT_INFORMATION10 IS NOT NULL
AND PET.ELEMENT_INFORMATION10 = PBT.BALANCE_TYPE_ID
AND PET.ELEMENT_INFORMATION12 = PBT2.BALANCE_TYPE_ID (+)
AND NVL(PPA.DATE_EARNED
, PPA.EFFECTIVE_DATE) BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND NVL(PPA.DATE_EARNED
, PPA.EFFECTIVE_DATE) BETWEEN ERNV.EFFECTIVE_START_DATE
AND ERNV.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 = ERNV.ELEMENT_TYPE_ID)

Columns