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

VIEW: APPS.PER_TIME_PERIODS1_DFV

Object Details
Object Name: PER_TIME_PERIODS1_DFV
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CONTEXT_VALUE VARCHAR2 (30)
HOLIDAY_ALLOWANCE___TO_PAY NUMBER

SUMMER_HOLIDAY_PAY__ NUMBER

SUMMER_HOLIDAY__BONUS__ NUMBER

WINTER_HOLIDAY_PAY__ NUMBER

WINTER_HOLIDAY__BONUS__ NUMBER

HOLIDAY_COMPENSATION__ NUMBER

PAYROLL VARCHAR2 (150)
PAYMENT_PERIOD VARCHAR2 (150)
SSP_PERIOD_STATUS VARCHAR2 (150)
WITHHOLDING_TAX VARCHAR2 (150)
PAY_HOLIDAY VARCHAR2 (150)
PAY_SAVED_HOLIDAY_PAY VARCHAR2 (150)
DUMMY1 VARCHAR2 (150)
NO_OF_SAVED_DAYS NUMBER

PAY_REMAINING_SAVED_DAYS VARCHAR2 (150)
PAY_ADDITIONAL_HOLIDAY_PAY VARCHAR2 (150)
DUMMY2 VARCHAR2 (150)
NUMBER_OF_HOLIDAY_DAYS NUMBER

PAY_REMAINING_HOLIDAY_DAYS VARCHAR2 (150)
PAYROLL_TAX_YEAR NUMBER

PAYROLL_TAX_QUARTER NUMBER

PAYROLL_CALENDAR_YEAR NUMBER

CONCATENATED_SEGMENTS VARCHAR2 (1238)
Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      HOLIDAY_ALLOWANCE___TO_PAY
,      SUMMER_HOLIDAY_PAY__
,      SUMMER_HOLIDAY__BONUS__
,      WINTER_HOLIDAY_PAY__
,      WINTER_HOLIDAY__BONUS__
,      HOLIDAY_COMPENSATION__
,      PAYROLL
,      PAYMENT_PERIOD
,      SSP_PERIOD_STATUS
,      WITHHOLDING_TAX
,      PAY_HOLIDAY
,      PAY_SAVED_HOLIDAY_PAY
,      DUMMY1
,      NO_OF_SAVED_DAYS
,      PAY_REMAINING_SAVED_DAYS
,      PAY_ADDITIONAL_HOLIDAY_PAY
,      DUMMY2
,      NUMBER_OF_HOLIDAY_DAYS
,      PAY_REMAINING_HOLIDAY_DAYS
,      PAYROLL_TAX_YEAR
,      PAYROLL_TAX_QUARTER
,      PAYROLL_CALENDAR_YEAR
,      CONCATENATED_SEGMENTS
FROM APPS.PER_TIME_PERIODS1_DFV;

Dependencies

[top of page]

APPS.PER_TIME_PERIODS1_DFV references the following:

SchemaAPPS
PL/SQL PackageFND_NUMBER - show dependent code
SynonymPER_TIME_PERIODS

APPS.PER_TIME_PERIODS1_DFV is not referenced by any database object