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

VIEW: APPS.PAY_JP_PRE_TAX

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID
PRE_TAX_ID NUMBER (15) Yes Primary Key
ACTION_ID NUMBER

Action iD
ASSIGNMENT_ACTION_ID NUMBER

Assignment Action ID
ASSIGNMENT_ACTION_ID_PERF VARCHAR2 (240)
ACTION_STATUS CHAR (1)
Action Status
SALARY_CATEGORY VARCHAR2 (240)
Salary Category
TAXABLE_SAL_AMT NUMBER

Taxable Salary
TAXABLE_MAT_AMT NUMBER

Taxable Material
PREVIOUS_TAXABLE_AMT NUMBER

Previous Taxable Amount
HI_ORGANIZATION_ID NUMBER

Health Insurance Organization
HI_PREM_EE NUMBER

HI Employee premium
HI_PREM_ER NUMBER

HI Employer Premium
WP_ORGANIZATION_ID NUMBER

Welfare Pension Organization
WP_PREM_EE NUMBER

WP Employee Premium
WP_PREM_ER NUMBER

WP Employer Premium
WPF_ORGANIZATION_ID NUMBER

Welfare Pension Fund Organization
WPF_PREM_EE NUMBER

WPF Employee Premium
WPF_PREM_ER NUMBER

WPF Employer premium
UI_ORGANIZATION_ID NUMBER

Unemploment Insurance Organization
UI_CATEGORY VARCHAR2 (240)
UI Category
UI_PREM_EE NUMBER

UI Employee Premium
UI_SAL_AMT NUMBER

UI Salary AMount
WAI_ORGANIZATION_ID NUMBER

WAI Organization
WAI_CATEGORY VARCHAR2 (240)
WAI Category
WAI_SAL_AMT NUMBER

WAI Salary AMount
ITAX_ORGANIZATION_ID NUMBER

Income tax organization
ITAX_CATEGORY VARCHAR2 (240)
Income tax category
ITAX_YEA_CATEGORY VARCHAR2 (240)
Income tax year end category
ITAX NUMBER

Income Tax
ITAX_ADJUSTMENT NUMBER

Income Tax Adjustment
PREVIOUS_ITAX NUMBER

Previous Income Tax
LTAX_ORGANIZATION_ID NUMBER

Local Tax Organization
LTAX_DISTRICT_CODE VARCHAR2 (240)
Local Tax District Code
LTAX_SWOT_NO VARCHAR2 (240)
Local Tax SWOT
LTAX NUMBER

Local Tax
LTAX_LUMPSUM NUMBER

Local Tax Lump Sum
SP_LTAX NUMBER

SP Local Tax
SP_LTAX_INCOME NUMBER

SP Local Tax Income
SP_LTAX_SHI NUMBER

SP Local Tax SHI
SP_LTAX_TO NUMBER

SP Local Tax TO
CI_PREM_EE NUMBER

CI Employee Premium
CI_PREM_ER NUMBER

CI Employer Premium
MUTUAL_AID NUMBER

Mutual Aid AMount
DISASTER_TAX_REDUCTION NUMBER

Disaster tax reduction amount
SP_LTAX_DISTRICT_CODE VARCHAR2 (240)
SP Local Tax District Code
Query Text

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


SELECT ROW_ID
,      PRE_TAX_ID
,      ACTION_ID
,      ASSIGNMENT_ACTION_ID
,      ASSIGNMENT_ACTION_ID_PERF
,      ACTION_STATUS
,      SALARY_CATEGORY
,      TAXABLE_SAL_AMT
,      TAXABLE_MAT_AMT
,      PREVIOUS_TAXABLE_AMT
,      HI_ORGANIZATION_ID
,      HI_PREM_EE
,      HI_PREM_ER
,      WP_ORGANIZATION_ID
,      WP_PREM_EE
,      WP_PREM_ER
,      WPF_ORGANIZATION_ID
,      WPF_PREM_EE
,      WPF_PREM_ER
,      UI_ORGANIZATION_ID
,      UI_CATEGORY
,      UI_PREM_EE
,      UI_SAL_AMT
,      WAI_ORGANIZATION_ID
,      WAI_CATEGORY
,      WAI_SAL_AMT
,      ITAX_ORGANIZATION_ID
,      ITAX_CATEGORY
,      ITAX_YEA_CATEGORY
,      ITAX
,      ITAX_ADJUSTMENT
,      PREVIOUS_ITAX
,      LTAX_ORGANIZATION_ID
,      LTAX_DISTRICT_CODE
,      LTAX_SWOT_NO
,      LTAX
,      LTAX_LUMPSUM
,      SP_LTAX
,      SP_LTAX_INCOME
,      SP_LTAX_SHI
,      SP_LTAX_TO
,      CI_PREM_EE
,      CI_PREM_ER
,      MUTUAL_AID
,      DISASTER_TAX_REDUCTION
,      SP_LTAX_DISTRICT_CODE
FROM APPS.PAY_JP_PRE_TAX;

Dependencies

[top of page]

APPS.PAY_JP_PRE_TAX references the following:

SchemaAPPS
PL/SQL PackageFND_NUMBER - show dependent code
SynonymPAY_ACTION_INFORMATION
APPS.PAY_JP_PRE_TAX is referenced by following:

SchemaAPPS
ViewPAYBV_JP_PRE_TAX_V
ViewPAY_JP_ITAX_WITHHELD_V
Package BodyPAY_JP_IWHT_ARCH_PKG - show dependent code
ViewPAY_JP_LABOR_INS_V
ViewPAY_JP_PRE_ITAX_V
ViewPAY_JP_PRE_ITAX_V2
ViewPAY_JP_PRE_TAX_V
Package BodyPAY_JP_SPR_EFILE_PKG - show dependent code
Package BodyPAY_PAYJPITT_XMLP_PKG - show dependent code