DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PAY_CA_EMP_PROV_TAX_INFO_V

Object Details
Object Name: PAY_CA_EMP_PROV_TAX_INFO_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_CA_EMP_PROV_TAX_INFO_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row id of pa_ca_emp_prov_tax_info_f
EMP_PROVINCE_TAX_INF_ID NUMBER (9) Yes Primary key column for pay_ca_emp_prov_tax_info_f
EFFECTIVE_START_DATE DATE
Yes Effective start date of the row
EFFECTIVE_END_DATE DATE
Yes Effective end date of the row
LEGISLATION_CODE VARCHAR2 (30) Yes Legislation code
ASSIGNMENT_ID NUMBER (10) Yes Assignment id, foreign key column for per_assignment
BUSINESS_GROUP_ID NUMBER (9) Yes Business group id, foreign key column for
PROVINCE_CODE VARCHAR2 (30) Yes
PROVINCE_NAME VARCHAR2 (80)
JURISDICTION_CODE VARCHAR2 (11)
TAX_CREDIT_AMOUNT NUMBER (11)
DEDUCTION_CODE VARCHAR2 (30)
EXTRA_INFO_NOT_PROVIDED VARCHAR2 (30)
MARRIAGE_STATUS VARCHAR2 (30)
NO_OF_INFIRM_DEPENDANTS NUMBER (30)
NON_RESIDENT_STATUS VARCHAR2 (30)
DISABILITY_STATUS VARCHAR2 (30)
NO_OF_DEPENDANTS NUMBER (30)
ANNUAL_DEDN NUMBER (11)
TOTAL_EXPENSE_BY_COMMISSION NUMBER (11)
TOTAL_REMNRTN_BY_COMMISSION NUMBER (11)
PRESCRIBED_ZONE_DEDN_AMT NUMBER (11)
BASIC_EXEMPTION_FLAG VARCHAR2 (30)
ADDITIONAL_TAX NUMBER (11)
PROV_OVERRIDE_RATE NUMBER (5)
PROV_OVERRIDE_AMOUNT NUMBER (11)
PROV_EXEMPT_FLAG VARCHAR2 (30)
PMED_EXEMPT_FLAG VARCHAR2 (30)
WC_EXEMPT_FLAG VARCHAR2 (30)
QPP_EXEMPT_FLAG VARCHAR2 (30)
OTHER_TAX_CREDIT NUMBER (11)
TAX_CALC_METHOD VARCHAR2 (240)
CALCULATION_METHOD VARCHAR2 (80)
CA_TAX_INFORMATION_CATEGORY VARCHAR2 (30)
CA_TAX_INFORMATION1 VARCHAR2 (150)
CA_TAX_INFORMATION2 VARCHAR2 (150)
CA_TAX_INFORMATION3 VARCHAR2 (150)
CA_TAX_INFORMATION4 VARCHAR2 (150)
CA_TAX_INFORMATION5 VARCHAR2 (150)
CA_TAX_INFORMATION6 VARCHAR2 (150)
CA_TAX_INFORMATION7 VARCHAR2 (150)
CA_TAX_INFORMATION8 VARCHAR2 (150)
CA_TAX_INFORMATION9 VARCHAR2 (150)
CA_TAX_INFORMATION10 VARCHAR2 (150)
CA_TAX_INFORMATION11 VARCHAR2 (150)
CA_TAX_INFORMATION12 VARCHAR2 (150)
CA_TAX_INFORMATION13 VARCHAR2 (150)
CA_TAX_INFORMATION14 VARCHAR2 (150)
CA_TAX_INFORMATION15 VARCHAR2 (150)
CA_TAX_INFORMATION16 VARCHAR2 (150)
CA_TAX_INFORMATION17 VARCHAR2 (150)
CA_TAX_INFORMATION18 VARCHAR2 (150)
CA_TAX_INFORMATION19 VARCHAR2 (150)
CA_TAX_INFORMATION20 VARCHAR2 (150)
CA_TAX_INFORMATION21 VARCHAR2 (150)
CA_TAX_INFORMATION22 VARCHAR2 (150)
CA_TAX_INFORMATION23 VARCHAR2 (150)
CA_TAX_INFORMATION24 VARCHAR2 (150)
CA_TAX_INFORMATION25 VARCHAR2 (150)
CA_TAX_INFORMATION26 VARCHAR2 (150)
CA_TAX_INFORMATION27 VARCHAR2 (150)
CA_TAX_INFORMATION28 VARCHAR2 (150)
CA_TAX_INFORMATION29 VARCHAR2 (150)
CA_TAX_INFORMATION30 VARCHAR2 (150)
PROV_LSP_AMOUNT NUMBER (11)
LAST_UPDATE_LOGIN NUMBER (30)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (30)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (30)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER NUMBER (30)
PPIP_EXEMPT_FLAG VARCHAR2 (30)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      EMP_PROVINCE_TAX_INF_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      LEGISLATION_CODE
,      ASSIGNMENT_ID
,      BUSINESS_GROUP_ID
,      PROVINCE_CODE
,      PROVINCE_NAME
,      JURISDICTION_CODE
,      TAX_CREDIT_AMOUNT
,      DEDUCTION_CODE
,      EXTRA_INFO_NOT_PROVIDED
,      MARRIAGE_STATUS
,      NO_OF_INFIRM_DEPENDANTS
,      NON_RESIDENT_STATUS
,      DISABILITY_STATUS
,      NO_OF_DEPENDANTS
,      ANNUAL_DEDN
,      TOTAL_EXPENSE_BY_COMMISSION
,      TOTAL_REMNRTN_BY_COMMISSION
,      PRESCRIBED_ZONE_DEDN_AMT
,      BASIC_EXEMPTION_FLAG
,      ADDITIONAL_TAX
,      PROV_OVERRIDE_RATE
,      PROV_OVERRIDE_AMOUNT
,      PROV_EXEMPT_FLAG
,      PMED_EXEMPT_FLAG
,      WC_EXEMPT_FLAG
,      QPP_EXEMPT_FLAG
,      OTHER_TAX_CREDIT
,      TAX_CALC_METHOD
,      CALCULATION_METHOD
,      CA_TAX_INFORMATION_CATEGORY
,      CA_TAX_INFORMATION1
,      CA_TAX_INFORMATION2
,      CA_TAX_INFORMATION3
,      CA_TAX_INFORMATION4
,      CA_TAX_INFORMATION5
,      CA_TAX_INFORMATION6
,      CA_TAX_INFORMATION7
,      CA_TAX_INFORMATION8
,      CA_TAX_INFORMATION9
,      CA_TAX_INFORMATION10
,      CA_TAX_INFORMATION11
,      CA_TAX_INFORMATION12
,      CA_TAX_INFORMATION13
,      CA_TAX_INFORMATION14
,      CA_TAX_INFORMATION15
,      CA_TAX_INFORMATION16
,      CA_TAX_INFORMATION17
,      CA_TAX_INFORMATION18
,      CA_TAX_INFORMATION19
,      CA_TAX_INFORMATION20
,      CA_TAX_INFORMATION21
,      CA_TAX_INFORMATION22
,      CA_TAX_INFORMATION23
,      CA_TAX_INFORMATION24
,      CA_TAX_INFORMATION25
,      CA_TAX_INFORMATION26
,      CA_TAX_INFORMATION27
,      CA_TAX_INFORMATION28
,      CA_TAX_INFORMATION29
,      CA_TAX_INFORMATION30
,      PROV_LSP_AMOUNT
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      PPIP_EXEMPT_FLAG
FROM APPS.PAY_CA_EMP_PROV_TAX_INFO_V;

Dependencies

[top of page]

APPS.PAY_CA_EMP_PROV_TAX_INFO_V references the following:

SchemaAPPS
SynonymFND_SESSIONS
PL/SQL PackageHR_API - show dependent code
ViewHR_LOOKUPS
SynonymPAY_CA_EMP_PROV_TAX_INFO_F

APPS.PAY_CA_EMP_PROV_TAX_INFO_V is not referenced by any database object