View: PAY_MX_TAX_BALANCES_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_MX_TAX_BALANCES_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 DATE_PAID
, PPA.DATE_EARNED
, PPA.BUSINESS_GROUP_ID
, PAA.RUN_TYPE_ID
, PBT.BALANCE_TYPE_ID BALANCE_TYPE_ID
, PAY_AC_UTILITY.GET_BALANCE_NAME(PBT.BALANCE_TYPE_ID) BALANCE_NAME
, PAY_AC_UTILITY.GET_BAL_REPORTING_NAME(PBT.BALANCE_TYPE_ID) REPORTING_NAME
, PBT.BALANCE_UOM
, PAY_AC_UTILITY.GET_VALUE ( PBT.BALANCE_TYPE_ID
, '_ASG_GRE_RUN'
, PBT.BUSINESS_GROUP_ID
, PBT.LEGISLATION_CODE
, PAA.ASSIGNMENT_ACTION_ID
, PAA.TAX_UNIT_ID
, PPA.EFFECTIVE_DATE ) RUN_VAL
, PAY_AC_UTILITY.GET_VALUE ( PBT.BALANCE_TYPE_ID
, '_ASG_GRE_YTD'
, PBT.BUSINESS_GROUP_ID
, PBT.LEGISLATION_CODE
, PAA.ASSIGNMENT_ACTION_ID
, PAA.TAX_UNIT_ID
, PPA.EFFECTIVE_DATE ) YTD_VAL
FROM PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_BALANCE_TYPES PBT
, PAY_DEFINED_BALANCES PDB
, PAY_BALANCE_ATTRIBUTES PBA
, PAY_BAL_ATTRIBUTE_DEFINITIONS PBAD
WHERE PBAD.ATTRIBUTE_NAME = 'SOE TAX BALANCES'
AND PBAD.BUSINESS_GROUP_ID IS NULL
AND PBAD.LEGISLATION_CODE = 'MX'
AND PBA.ATTRIBUTE_ID = PBAD.ATTRIBUTE_ID
AND ( ( PBA.BUSINESS_GROUP_ID IS NULL ) OR ( PBA.BUSINESS_GROUP_ID IS NOT NULL
AND PBA.BUSINESS_GROUP_ID = PPA.BUSINESS_GROUP_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 PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND EXISTS ( SELECT 1
FROM PAY_RUN_BALANCES PRB
WHERE PRB.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PRB.TAX_UNIT_ID = PAA.TAX_UNIT_ID
AND PRB.EFFECTIVE_DATE BETWEEN TRUNC(PPA.EFFECTIVE_DATE
, 'Y' )
AND PPA.EFFECTIVE_DATE
AND PRB.DEFINED_BALANCE_ID = PBA.DEFINED_BALANCE_ID )

Columns