[Home] [Help]
View: IGSFV_INCOME_TAXES
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | This entity contains information about the person's income tax details |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT '_LA:PIT.TAX_INFO:IGS_LOOKUP_VALUES:TAX_INFO:MEANING'
, NULL
, PIT.TYPE_CODE_ID
, PIT.START_DATE
, PIT.END_DATE
, GEO.GEOGRAPHY_NAME
, HZP.PARTY_NUMBER
, PIT.TAX_ID
, PIT.PERSON_ID
, PIT.CREATED_BY
, PIT.CREATION_DATE
, PIT.LAST_UPDATED_BY
, PIT.LAST_UPDATE_DATE
FROM IGS_PE_INCOME_TAX_ALL PIT
, HZ_PARTIES HZP
, HZ_GEOGRAPHIES GEO
WHERE PIT.PERSON_ID=HZP.PARTY_ID
AND PIT.TAX_INFO = GEO.GEOGRAPHY_TYPE
AND PIT.TAX_INFO IN ('STATE'
, 'COUNTY'
, 'CITY'
, 'PROVINCE')
AND PIT.TYPE_CODE_ID=GEO.GEOGRAPHY_ID
AND GEO.COUNTRY_CODE = FND_PROFILE.VALUE('OSS_COUNTRY_CODE') UNION ALL SELECT '_LA:PIT.TAX_INFO:IGS_LOOKUP_VALUES:TAX_INFO:MEANING'
, PIT.TYPE_CODE
, TO_NUMBER(NULL)
, PIT.START_DATE
, PIT.END_DATE
, COC.TERRITORY_SHORT_NAME
, HZP.PARTY_NUMBER
, PIT.TAX_ID
, PIT.PERSON_ID
, PIT.CREATED_BY
, PIT.CREATION_DATE
, PIT.LAST_UPDATED_BY
, PIT.LAST_UPDATE_DATE
FROM IGS_PE_INCOME_TAX_ALL PIT
, HZ_PARTIES HZP
, FND_TERRITORIES_TL COC
WHERE PIT.PERSON_ID=HZP.PARTY_ID
AND PIT.TAX_INFO = 'COUNTRY'
AND PIT.TYPE_CODE = COC.TERRITORY_CODE
AND LANGUAGE = USERENV('LANG') WITH READ ONLY
Columns
| Name |
| "_LA:TAX_INFO" |
| TYPE_CODE |
| TYPE_CODE_ID |
| START_DATE |
| END_DATE |
| DESCRIPTION |
| PERSON_NUMBER |
| TAX_ID |
| PERSON_ID |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |