View: PAY_US_BALANCE_VALUES_V

Product:	PAY - Payroll
Description:	Sales / ADS disco workbook req.
Implementation/DBA Data:	APPS.PAY_US_BALANCE_VALUES_V

View Text

SELECT PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PAA.PAYROLL_ACTION_ID
, PPA.EFFECTIVE_DATE
, PBT.BALANCE_TYPE_ID
, PBT.BALANCE_NAME
, PBD.BALANCE_DIMENSION_ID
, PBD.DIMENSION_NAME
, PBD.DATABASE_ITEM_SUFFIX
, PBD.DESCRIPTION DIMENSION_DESCRIPTION
, PDB.DEFINED_BALANCE_ID
, PBD.ROUTE_ID
, PAY_BALANCE_PKG.GET_VALUE(PDB.DEFINED_BALANCE_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.TAX_UNIT_ID
, PAC_JUR.JURISDICTION_CODE
, NULL
, PAC_TAX_GROUP.ORG_INFORMATION5
, PPA.EFFECTIVE_DATE) VALUE
, PAC_JUR.JURISDICTION_CODE
, PAC_TAX_GROUP.ORG_INFORMATION5 TAX_GROUP
FROM PAY_PAYROLL_ACTIONS PPA
, PAY_BALANCE_TYPES PBT
, PAY_BALANCE_DIMENSIONS PBD
, PAY_DEFINED_BALANCES PDB
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_US_ASG_REPORTING PAC_JUR
, HR_ORGANIZATION_INFORMATION PAC_TAX_GROUP
WHERE PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PDB.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID
AND PDB.BALANCE_DIMENSION_ID = PBD.BALANCE_DIMENSION_ID
AND PAA.ASSIGNMENT_ID = PAC_JUR.ASSIGNMENT_ID
AND PAA.TAX_UNIT_ID = PAC_TAX_GROUP.ORGANIZATION_ID
AND UPPER(PAC_TAX_GROUP.ORG_INFORMATION_CONTEXT) = 'FEDERAL TAX RULES'
AND PAC_JUR.ROWID = (SELECT MIN(PAR.ROWID)
FROM PAY_US_ASG_REPORTING PAR
WHERE PAR.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND DECODE(PBT.JURISDICTION_LEVEL
, 0
, PAR.JURISDICTION_CODE
, SUBSTR(PAR.JURISDICTION_CODE
, 1
, PBT.JURISDICTION_LEVEL)) = DECODE(PBT.JURISDICTION_LEVEL
, 0
, PAR.JURISDICTION_CODE
, SUBSTR(PAC_JUR.JURISDICTION_CODE
, 1
, PBT.JURISDICTION_LEVEL)) )
AND EXISTS (SELECT ''
FROM PAY_BALANCE_FEEDS_F PBF
, PAY_RUN_RESULT_VALUES PRRV
, PAY_RUN_RESULTS PRR
WHERE PRR.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PRR.RUN_RESULT_ID = PRRV.RUN_RESULT_ID
AND PRRV.INPUT_VALUE_ID = PBF.INPUT_VALUE_ID
AND PBF.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID
AND PPA.EFFECTIVE_DATE BETWEEN PBF.EFFECTIVE_START_DATE
AND PBF.EFFECTIVE_END_DATE )
AND NOT EXISTS (SELECT ''
FROM FF_ROUTE_CONTEXT_USAGES FRCU
, FF_CONTEXTS FC
WHERE FRCU.ROUTE_ID = PBD.ROUTE_ID
AND FC.CONTEXT_ID = FRCU.CONTEXT_ID
AND FC.CONTEXT_NAME NOT IN ('TAX_GROUP'
, 'JURISDICTION_CODE'
, 'TAX_UNIT_ID'
, 'ASSIGNMENT_ACTION_ID') )

Columns