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

VIEW: HR.PAY_PL_PAYE_DETAILS_F#

Object Details
Object Name: PAY_PL_PAYE_DETAILS_F#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PAYE_DETAILS_ID NUMBER (10) Yes
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
PER_OR_ASG_ID NUMBER (10) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
CONTRACT_CATEGORY VARCHAR2 (30) Yes
OBJECT_VERSION_NUMBER NUMBER (9) Yes
TAX_REDUCTION VARCHAR2 (30)
TAX_CALC_WITH_SPOUSE_CHILD VARCHAR2 (30)
INCOME_REDUCTION VARCHAR2 (30)
INCOME_REDUCTION_AMOUNT NUMBER (14)
RATE_OF_TAX VARCHAR2 (30)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_LOGIN_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
REQUEST_ID NUMBER (15)
Query Text

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


SELECT PAYE_DETAILS_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      PER_OR_ASG_ID
,      BUSINESS_GROUP_ID
,      CONTRACT_CATEGORY
,      OBJECT_VERSION_NUMBER
,      TAX_REDUCTION
,      TAX_CALC_WITH_SPOUSE_CHILD
,      INCOME_REDUCTION
,      INCOME_REDUCTION_AMOUNT
,      RATE_OF_TAX
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM HR.PAY_PL_PAYE_DETAILS_F#;

Dependencies

[top of page]

HR.PAY_PL_PAYE_DETAILS_F# references the following:

SchemaHR
TablePAY_PL_PAYE_DETAILS_F
HR.PAY_PL_PAYE_DETAILS_F# is referenced by following:

SchemaAPPS
SynonymPAY_PL_PAYE_DETAILS_F
TriggerPAY_PL_PAYE_DETAILS_F_WHO