[Home] [Help]
View: PAY_US_GTN_TAX_UNITS_V
View Text
SELECT DISTINCT TUV.TAX_UNIT_ID
, TUV.NAME
, HRL.LOCATION_ID
, HRL.LOCATION_CODE
, PAF.ORGANIZATION_ID
, NULL ORGANIZATION_NAME
, 'L' TYPE
FROM PAY_US_ASG_REPORTING ASG
, HR_TAX_UNITS_V TUV
, HR_LOCATIONS HRL
, PER_ALL_ASSIGNMENTS_F PAF
WHERE HRL.LOCATION_ID=PAF.LOCATION_ID
AND ASG.TAX_UNIT_ID=TUV.TAX_UNIT_ID
AND ASG.ASSIGNMENT_ID=PAF.ASSIGNMENT_ID
AND SYSDATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE UNION SELECT TUV.TAX_UNIT_ID
, TUV.NAME
, HRL.LOCATION_ID
, HRL.LOCATION_CODE
, PAF.ORGANIZATION_ID
, HOU.NAME ORGANIZATION_NAME
, 'O' TYPE
FROM PAY_US_ASG_REPORTING ASG
, HR_LOCATIONS HRL
, HR_TAX_UNITS_V TUV
, HR_ALL_ORGANIZATION_UNITS HOU
, PER_ALL_ASSIGNMENTS_F PAF
WHERE ASG.TAX_UNIT_ID=TUV.TAX_UNIT_ID
AND TUV.LOCATION_ID=HRL.LOCATION_ID
AND PAF.ASSIGNMENT_ID=ASG.ASSIGNMENT_ID
AND HOU.ORGANIZATION_ID=PAF.ORGANIZATION_ID
AND SYSDATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE UNION SELECT ASG.TAX_UNIT_ID
, TUV.NAME
, FND_NUMBER.CANONICAL_TO_NUMBER(NULL) LOCATION_ID
, NULL LOCATION_CODE
, FND_NUMBER.CANONICAL_TO_NUMBER(NULL) ORGANIZATION_ID
, NULL ORGANIZATION_NAME
, 'G' TYPE
FROM PAY_US_ASG_REPORTING ASG
, HR_TAX_UNITS_V TUV
WHERE TUV.TAX_UNIT_ID=ASG.TAX_UNIT_ID
Columns
Name |
TAX_UNIT_ID |
NAME |
LOCATION_ID |
LOCATION_CODE |
ORGANIZATION_ID |
ORGANIZATION_NAME |
TYPE |