[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PAY_IN_TAX_DECLARATIONS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PAY.PAY_IN_TAX_DECLARATIONS_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_ID | NUMBER | (10) | Yes | |
| FULL_NAME | VARCHAR2 | (240) | ||
| EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
| ASSIGNMENT_ID | NUMBER | (10) | Yes | |
| ASSIGNMENT_NUMBER | VARCHAR2 | (30) | ||
| EFFECTIVE_DATE | DATE | |||
| DEPARTMENT | VARCHAR2 | (240) | Yes | |
| LAST_UPDATED_DATE | DATE | |||
| ORGANIZATION_ID | NUMBER | (15) | Yes | |
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
| START_DATE | DATE | Yes | ||
| GRADE_ID | NUMBER | (15) | ||
| JOB_ID | NUMBER | (15) | ||
| POSITION_ID | NUMBER | (15) | ||
| TAX_AREA_NUMBER | VARCHAR2 | (150) | ||
| APPROVAL_STATUS | VARCHAR2 | (150) | ||
| TAX_YEAR | VARCHAR2 | (150) | ||
| APRIL | NUMBER | |||
| MAY | NUMBER | |||
| JUNE | NUMBER | |||
| JULY | NUMBER | |||
| AUGUST | NUMBER | |||
| SEPTEMBER | NUMBER | |||
| OCTOBER | NUMBER | |||
| NOVEMBER | NUMBER | |||
| DECEMBER | NUMBER | |||
| JANUARY | NUMBER | |||
| FEBRUARY | NUMBER | |||
| MARCH | NUMBER | |||
| CCE_EE_ID1 | VARCHAR2 | (4000) | ||
| COMPONENT1 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT1 | VARCHAR2 | (4000) | ||
| CCE_EE_ID2 | VARCHAR2 | (4000) | ||
| COMPONENT2 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT2 | VARCHAR2 | (4000) | ||
| CCE_EE_ID3 | VARCHAR2 | (4000) | ||
| COMPONENT3 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT3 | VARCHAR2 | (4000) | ||
| CCE_EE_ID4 | VARCHAR2 | (4000) | ||
| COMPONENT4 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT4 | VARCHAR2 | (4000) | ||
| CCE_EE_ID5 | VARCHAR2 | (4000) | ||
| COMPONENT5 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT5 | VARCHAR2 | (4000) | ||
| CCE_EE_ID6 | VARCHAR2 | (4000) | ||
| COMPONENT6 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT6 | VARCHAR2 | (4000) | ||
| CCE_EE_ID7 | VARCHAR2 | (4000) | ||
| COMPONENT7 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT7 | VARCHAR2 | (4000) | ||
| CCE_EE_ID8 | VARCHAR2 | (4000) | ||
| COMPONENT8 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT8 | VARCHAR2 | (4000) | ||
| CCE_EE_ID9 | VARCHAR2 | (4000) | ||
| COMPONENT9 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT9 | VARCHAR2 | (4000) | ||
| CCE_EE_ID10 | VARCHAR2 | (4000) | ||
| COMPONENT10 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT10 | VARCHAR2 | (4000) | ||
| CCE_EE_ID11 | VARCHAR2 | (4000) | ||
| COMPONENT11 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT11 | VARCHAR2 | (4000) | ||
| CCE_EE_ID12 | VARCHAR2 | (4000) | ||
| COMPONENT12 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT12 | VARCHAR2 | (4000) | ||
| CCE_EE_ID13 | VARCHAR2 | (4000) | ||
| COMPONENT13 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT13 | VARCHAR2 | (4000) | ||
| CCE_EE_ID14 | VARCHAR2 | (4000) | ||
| COMPONENT14 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT14 | VARCHAR2 | (4000) | ||
| CCE_EE_ID15 | VARCHAR2 | (4000) | ||
| COMPONENT15 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT15 | VARCHAR2 | (4000) | ||
| CCE_EE_ID16 | VARCHAR2 | (4000) | ||
| COMPONENT16 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT16 | VARCHAR2 | (4000) | ||
| CCE_EE_ID17 | VARCHAR2 | (4000) | ||
| COMPONENT17 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT17 | VARCHAR2 | (4000) | ||
| CCE_EE_ID18 | VARCHAR2 | (4000) | ||
| COMPONENT18 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT18 | VARCHAR2 | (4000) | ||
| CCE_EE_ID19 | VARCHAR2 | (4000) | ||
| COMPONENT19 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT19 | VARCHAR2 | (4000) | ||
| CCE_EE_ID20 | VARCHAR2 | (4000) | ||
| COMPONENT20 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT20 | VARCHAR2 | (4000) | ||
| CCE_EE_ID21 | VARCHAR2 | (4000) | ||
| COMPONENT21 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT21 | VARCHAR2 | (4000) | ||
| HIGHER_EDUCATION_LOAN | NUMBER | |||
| DONATION_FOR_RESEARCH | NUMBER | |||
| CLAIM_EXEMPTION_SEC_80GG | VARCHAR2 | (4000) | ||
| PREMIUM_AMOUNT | NUMBER | |||
| PREMIUM_COVERS_SC | VARCHAR2 | (4000) | ||
| PARENT_PREMIUM | NUMBER | |||
| PARENT_SC | VARCHAR2 | (4000) | ||
| TREATMENT_AMOUNT | NUMBER | |||
| TREATMENT_COVERS_SC | VARCHAR2 | (4000) | ||
| INCOME_FROM_HOUSE_PROPERTY | NUMBER | |||
| PROFIT_AND_GAIN | NUMBER | |||
| LONG_TERM_CAPITAL_GAIN | NUMBER | |||
| SHORT_TERM_CAPITAL_GAIN | NUMBER | |||
| INCOME_FROM_OTHER_SOURCES | NUMBER | |||
| TDS_PAID | NUMBER | |||
| DISEASE_ENTRY_ID1 | VARCHAR2 | (4000) | ||
| DISABILITY_TYPE1 | VARCHAR2 | (4000) | ||
| DISABILITY_PERCENTAGE1 | VARCHAR2 | (4000) | ||
| TREATMENT_AMOUNT1 | VARCHAR2 | (4000) | ||
| DISEASE_ENTRY_ID2 | VARCHAR2 | (4000) | ||
| DISABILITY_TYPE2 | VARCHAR2 | (4000) | ||
| DISABILITY_PERCENTAGE2 | VARCHAR2 | (4000) | ||
| TREATMENT_AMOUNT2 | VARCHAR2 | (4000) | ||
| DONATION_ENTRY_ID1 | VARCHAR2 | (4000) | ||
| DONATION_TYPE1 | VARCHAR2 | (4000) | ||
| DONATION_AMOUNT1 | VARCHAR2 | (4000) | ||
| DONATION_ENTRY_ID2 | VARCHAR2 | (4000) | ||
| DONATION_TYPE2 | VARCHAR2 | (4000) | ||
| DONATION_AMOUNT2 | VARCHAR2 | (4000) | ||
| LIC_ENTRY_ID1 | VARCHAR2 | (4000) | ||
| PREMIUM_PAID1 | VARCHAR2 | (4000) | ||
| SUM_ASSURED1 | VARCHAR2 | (4000) | ||
| POLICY_NUMBER1 | VARCHAR2 | (4000) | ||
| LIC_ENTRY_ID2 | VARCHAR2 | (4000) | ||
| PREMIUM_PAID2 | VARCHAR2 | (4000) | ||
| SUM_ASSURED2 | VARCHAR2 | (4000) | ||
| POLICY_NUMBER2 | VARCHAR2 | (4000) | ||
| LIC_ENTRY_ID3 | VARCHAR2 | (4000) | ||
| PREMIUM_PAID3 | VARCHAR2 | (4000) | ||
| SUM_ASSURED3 | VARCHAR2 | (4000) | ||
| POLICY_NUMBER3 | VARCHAR2 | (4000) | ||
| LIC_ENTRY_ID4 | VARCHAR2 | (4000) | ||
| PREMIUM_PAID4 | VARCHAR2 | (4000) | ||
| SUM_ASSURED4 | VARCHAR2 | (4000) | ||
| POLICY_NUMBER4 | VARCHAR2 | (4000) | ||
| LIC_ENTRY_ID5 | VARCHAR2 | (4000) | ||
| PREMIUM_PAID5 | VARCHAR2 | (4000) | ||
| SUM_ASSURED5 | VARCHAR2 | (4000) | ||
| POLICY_NUMBER5 | VARCHAR2 | (4000) | ||
| LIC_ENTRY_ID6 | VARCHAR2 | (4000) | ||
| PREMIUM_PAID6 | VARCHAR2 | (4000) | ||
| SUM_ASSURED6 | VARCHAR2 | (4000) | ||
| POLICY_NUMBER6 | VARCHAR2 | (4000) | ||
| LIC_ENTRY_ID7 | VARCHAR2 | (4000) | ||
| PREMIUM_PAID7 | VARCHAR2 | (4000) | ||
| SUM_ASSURED7 | VARCHAR2 | (4000) | ||
| POLICY_NUMBER7 | VARCHAR2 | (4000) | ||
| LIC_ENTRY_ID8 | VARCHAR2 | (4000) | ||
| PREMIUM_PAID8 | VARCHAR2 | (4000) | ||
| SUM_ASSURED8 | VARCHAR2 | (4000) | ||
| POLICY_NUMBER8 | VARCHAR2 | (4000) | ||
| LIC_ENTRY_ID9 | VARCHAR2 | (4000) | ||
| PREMIUM_PAID9 | VARCHAR2 | (4000) | ||
| SUM_ASSURED9 | VARCHAR2 | (4000) | ||
| POLICY_NUMBER9 | VARCHAR2 | (4000) | ||
| LIC_ENTRY_ID10 | VARCHAR2 | (4000) | ||
| PREMIUM_PAID10 | VARCHAR2 | (4000) | ||
| SUM_ASSURED10 | VARCHAR2 | (4000) | ||
| POLICY_NUMBER10 | VARCHAR2 | (4000) | ||
| LIC_ENTRY_ID11 | VARCHAR2 | (4000) | ||
| PREMIUM_PAID11 | VARCHAR2 | (4000) | ||
| SUM_ASSURED11 | VARCHAR2 | (4000) | ||
| POLICY_NUMBER11 | VARCHAR2 | (4000) | ||
| LIC_ENTRY_ID12 | VARCHAR2 | (4000) | ||
| PREMIUM_PAID12 | VARCHAR2 | (4000) | ||
| SUM_ASSURED12 | VARCHAR2 | (4000) | ||
| POLICY_NUMBER12 | VARCHAR2 | (4000) | ||
| COMMENT_TEXT | VARCHAR2 | (150) | ||
| ISB_AMOUNT | NUMBER | |||
| VPF_AMOUNT | NUMBER | |||
| VPF_PERCENT | NUMBER | |||
| CCE_EE_ID22 | VARCHAR2 | (4000) | ||
| COMPONENT22 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT22 | VARCHAR2 | (4000) | ||
| CCE_EE_ID23 | VARCHAR2 | (4000) | ||
| COMPONENT23 | VARCHAR2 | (4000) | ||
| INVESTMENT_AMOUNT23 | VARCHAR2 | (4000) | ||
| POLICY_START_DATE1 | VARCHAR2 | (4000) | ||
| POLICY_START_DATE2 | VARCHAR2 | (4000) | ||
| POLICY_START_DATE3 | VARCHAR2 | (4000) | ||
| POLICY_START_DATE4 | VARCHAR2 | (4000) | ||
| POLICY_START_DATE5 | VARCHAR2 | (4000) | ||
| POLICY_START_DATE6 | VARCHAR2 | (4000) | ||
| POLICY_START_DATE7 | VARCHAR2 | (4000) | ||
| POLICY_START_DATE8 | VARCHAR2 | (4000) | ||
| POLICY_START_DATE9 | VARCHAR2 | (4000) | ||
| POLICY_START_DATE10 | VARCHAR2 | (4000) | ||
| POLICY_START_DATE11 | VARCHAR2 | (4000) | ||
| POLICY_START_DATE12 | VARCHAR2 | (4000) | ||
| HEALTH_CHECKUP | NUMBER | |||
| HEALTH_CHECKUP_FOR_PARENTS | NUMBER | |||
| INTEREST_ON_DEPOSIT | NUMBER | |||
| SEC_80CCG_DATE_OF_INVESTMENT | VARCHAR2 | (10) | ||
| SEC_80CCG_INVESTMENT_AMOUNT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, FULL_NAME
, EMPLOYEE_NUMBER
, ASSIGNMENT_ID
, ASSIGNMENT_NUMBER
, EFFECTIVE_DATE
, DEPARTMENT
, LAST_UPDATED_DATE
, ORGANIZATION_ID
, BUSINESS_GROUP_ID
, START_DATE
, GRADE_ID
, JOB_ID
, POSITION_ID
, TAX_AREA_NUMBER
, APPROVAL_STATUS
, TAX_YEAR
, APRIL
, MAY
, JUNE
, JULY
, AUGUST
, SEPTEMBER
, OCTOBER
, NOVEMBER
, DECEMBER
, JANUARY
, FEBRUARY
, MARCH
, CCE_EE_ID1
, COMPONENT1
, INVESTMENT_AMOUNT1
, CCE_EE_ID2
, COMPONENT2
, INVESTMENT_AMOUNT2
, CCE_EE_ID3
, COMPONENT3
, INVESTMENT_AMOUNT3
, CCE_EE_ID4
, COMPONENT4
, INVESTMENT_AMOUNT4
, CCE_EE_ID5
, COMPONENT5
, INVESTMENT_AMOUNT5
, CCE_EE_ID6
, COMPONENT6
, INVESTMENT_AMOUNT6
, CCE_EE_ID7
, COMPONENT7
, INVESTMENT_AMOUNT7
, CCE_EE_ID8
, COMPONENT8
, INVESTMENT_AMOUNT8
, CCE_EE_ID9
, COMPONENT9
, INVESTMENT_AMOUNT9
, CCE_EE_ID10
, COMPONENT10
, INVESTMENT_AMOUNT10
, CCE_EE_ID11
, COMPONENT11
, INVESTMENT_AMOUNT11
, CCE_EE_ID12
, COMPONENT12
, INVESTMENT_AMOUNT12
, CCE_EE_ID13
, COMPONENT13
, INVESTMENT_AMOUNT13
, CCE_EE_ID14
, COMPONENT14
, INVESTMENT_AMOUNT14
, CCE_EE_ID15
, COMPONENT15
, INVESTMENT_AMOUNT15
, CCE_EE_ID16
, COMPONENT16
, INVESTMENT_AMOUNT16
, CCE_EE_ID17
, COMPONENT17
, INVESTMENT_AMOUNT17
, CCE_EE_ID18
, COMPONENT18
, INVESTMENT_AMOUNT18
, CCE_EE_ID19
, COMPONENT19
, INVESTMENT_AMOUNT19
, CCE_EE_ID20
, COMPONENT20
, INVESTMENT_AMOUNT20
, CCE_EE_ID21
, COMPONENT21
, INVESTMENT_AMOUNT21
, HIGHER_EDUCATION_LOAN
, DONATION_FOR_RESEARCH
, CLAIM_EXEMPTION_SEC_80GG
, PREMIUM_AMOUNT
, PREMIUM_COVERS_SC
, PARENT_PREMIUM
, PARENT_SC
, TREATMENT_AMOUNT
, TREATMENT_COVERS_SC
, INCOME_FROM_HOUSE_PROPERTY
, PROFIT_AND_GAIN
, LONG_TERM_CAPITAL_GAIN
, SHORT_TERM_CAPITAL_GAIN
, INCOME_FROM_OTHER_SOURCES
, TDS_PAID
, DISEASE_ENTRY_ID1
, DISABILITY_TYPE1
, DISABILITY_PERCENTAGE1
, TREATMENT_AMOUNT1
, DISEASE_ENTRY_ID2
, DISABILITY_TYPE2
, DISABILITY_PERCENTAGE2
, TREATMENT_AMOUNT2
, DONATION_ENTRY_ID1
, DONATION_TYPE1
, DONATION_AMOUNT1
, DONATION_ENTRY_ID2
, DONATION_TYPE2
, DONATION_AMOUNT2
, LIC_ENTRY_ID1
, PREMIUM_PAID1
, SUM_ASSURED1
, POLICY_NUMBER1
, LIC_ENTRY_ID2
, PREMIUM_PAID2
, SUM_ASSURED2
, POLICY_NUMBER2
, LIC_ENTRY_ID3
, PREMIUM_PAID3
, SUM_ASSURED3
, POLICY_NUMBER3
, LIC_ENTRY_ID4
, PREMIUM_PAID4
, SUM_ASSURED4
, POLICY_NUMBER4
, LIC_ENTRY_ID5
, PREMIUM_PAID5
, SUM_ASSURED5
, POLICY_NUMBER5
, LIC_ENTRY_ID6
, PREMIUM_PAID6
, SUM_ASSURED6
, POLICY_NUMBER6
, LIC_ENTRY_ID7
, PREMIUM_PAID7
, SUM_ASSURED7
, POLICY_NUMBER7
, LIC_ENTRY_ID8
, PREMIUM_PAID8
, SUM_ASSURED8
, POLICY_NUMBER8
, LIC_ENTRY_ID9
, PREMIUM_PAID9
, SUM_ASSURED9
, POLICY_NUMBER9
, LIC_ENTRY_ID10
, PREMIUM_PAID10
, SUM_ASSURED10
, POLICY_NUMBER10
, LIC_ENTRY_ID11
, PREMIUM_PAID11
, SUM_ASSURED11
, POLICY_NUMBER11
, LIC_ENTRY_ID12
, PREMIUM_PAID12
, SUM_ASSURED12
, POLICY_NUMBER12
, COMMENT_TEXT
, ISB_AMOUNT
, VPF_AMOUNT
, VPF_PERCENT
, CCE_EE_ID22
, COMPONENT22
, INVESTMENT_AMOUNT22
, CCE_EE_ID23
, COMPONENT23
, INVESTMENT_AMOUNT23
, POLICY_START_DATE1
, POLICY_START_DATE2
, POLICY_START_DATE3
, POLICY_START_DATE4
, POLICY_START_DATE5
, POLICY_START_DATE6
, POLICY_START_DATE7
, POLICY_START_DATE8
, POLICY_START_DATE9
, POLICY_START_DATE10
, POLICY_START_DATE11
, POLICY_START_DATE12
, HEALTH_CHECKUP
, HEALTH_CHECKUP_FOR_PARENTS
, INTEREST_ON_DEPOSIT
, SEC_80CCG_DATE_OF_INVESTMENT
, SEC_80CCG_INVESTMENT_AMOUNT
FROM APPS.PAY_IN_TAX_DECLARATIONS_V;
APPS
FND_DATE
- show dependent code
HR_GENERAL
- show dependent code
HR_ORGANIZATION_INFORMATION
HR_ORGANIZATION_UNITS
HR_PERSON_NAME
- show dependent code
HR_SECURITY
- show dependent code
HR_SOFT_CODING_KEYFLEX
PAY_IN_TAX_DECLARATION
- show dependent code
PER_ASSIGNMENTS_F
PER_ASSIGNMENT_EXTRA_INFO
PER_PEOPLE_F
PER_PERSON_TYPES
APPS.PAY_IN_TAX_DECLARATIONS_V is not referenced by any database object
|
|
|
|