eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: HR.PAY_JP_PRE_TAX_OLD#

Object Details

Object Name:	PAY_JP_PRE_TAX_OLD#
Object Type:	VIEW
Owner:	HR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
PRE_TAX_ID	NUMBER	(15)	Yes
ACTION_ID	NUMBER	(9)	Yes
ASSIGNMENT_ACTION_ID	NUMBER	(15)	Yes
ACTION_STATUS	VARCHAR2	(1)	Yes
SALARY_CATEGORY	VARCHAR2	(30)
TAXABLE_SAL_AMT	NUMBER	(38)	Yes
TAXABLE_MAT_AMT	NUMBER	(38)	Yes
PREVIOUS_TAXABLE_AMT	NUMBER	(38)	Yes
HI_ORGANIZATION_ID	NUMBER	(15)
HI_PREM_EE	NUMBER	(38)	Yes
HI_PREM_ER	NUMBER	(38)	Yes
WP_ORGANIZATION_ID	NUMBER	(15)
WP_PREM_EE	NUMBER	(38)	Yes
WP_PREM_ER	NUMBER	(38)	Yes
WPF_ORGANIZATION_ID	NUMBER	(15)
WPF_PREM_EE	NUMBER	(38)	Yes
WPF_PREM_ER	NUMBER	(38)	Yes
UI_ORGANIZATION_ID	NUMBER	(15)
UI_CATEGORY	VARCHAR2	(30)
UI_PREM_EE	NUMBER	(38)	Yes
UI_SAL_AMT	NUMBER	(38)	Yes
WAI_ORGANIZATION_ID	NUMBER	(15)
WAI_CATEGORY	VARCHAR2	(30)
WAI_SAL_AMT	NUMBER	(38)	Yes
ITAX_ORGANIZATION_ID	NUMBER	(15)
ITAX_CATEGORY	VARCHAR2	(30)
ITAX_YEA_CATEGORY	VARCHAR2	(30)
ITAX	NUMBER	(38)	Yes
ITAX_ADJUSTMENT	NUMBER	(38)	Yes
PREVIOUS_ITAX	NUMBER	(38)	Yes
LTAX_ORGANIZATION_ID	NUMBER	(15)
LTAX_DISTRICT_CODE	VARCHAR2	(30)
LTAX_SWOT_NO	VARCHAR2	(30)
LTAX	NUMBER	(38)	Yes
LTAX_LUMPSUM	NUMBER	(38)	Yes
SP_LTAX	NUMBER	(38)	Yes
SP_LTAX_INCOME	NUMBER	(38)	Yes
SP_LTAX_SHI	NUMBER	(38)	Yes
SP_LTAX_TO	NUMBER	(38)	Yes
CI_PREM_EE	NUMBER	(38)	Yes
CI_PREM_ER	NUMBER	(38)	Yes
MUTUAL_AID	NUMBER	(38)	Yes
DISASTER_TAX_REDUCTION	NUMBER	(38)	Yes
SP_LTAX_DISTRICT_CODE	VARCHAR2	(30)

Query Text

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


SELECT PRE_TAX_ID
,      ACTION_ID
,      ASSIGNMENT_ACTION_ID
,      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 HR.PAY_JP_PRE_TAX_OLD#;

Dependencies

[top of page]

HR.PAY_JP_PRE_TAX_OLD# references the following:

HR: PAY_JP_PRE_TAX_OLD

HR.PAY_JP_PRE_TAX_OLD# is referenced by following:

APPS: PAY_JP_PRE_TAX_OLD