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: APPS.PER_CONTRACTS_F_DFV

Object Details

Object Name:	PER_CONTRACTS_F_DFV
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
CONTEXT_VALUE	VARCHAR2	(30)
EMPLOYMENT_STATUS	VARCHAR2	(150)
EXPIRY_DATE	DATE
CONTRACT_CATEGORY	VARCHAR2	(150)
FIRST_DATE_WORKED	DATE
LAST_DATE_WORKED	DATE
PAYMENT_START_DATE	DATE
PAYMENT_END_DATE	DATE
NOTICE_PERIOD	NUMBER
NOTICE_PERIOD_UNITS	VARCHAR2	(150)
REPLACING_EMPLOYEE	VARCHAR2	(150)
CONTRACT_SIGN_OFF_DATE	DATE
DURATION_OF_PROBATION_LENGTH	VARCHAR2	(150)
PROBATION_DURATION_UNIT	VARCHAR2	(150)
CONST__PROBATION_END_DATE	DATE
ACTUAL_PROBATION_END_DATE	DATE
NOTICE_PERIOD__RESIGN_IN_PROB	VARCHAR2	(150)
NOTICE_PERIOD__DISMISS_IN_PROB	VARCHAR2	(150)
NOTICE_PERIOD__RESIGNATION	VARCHAR2	(150)
NOTICE_PERIOD__DISMISSAL	VARCHAR2	(150)
NOTICE_DURATION_UNIT	VARCHAR2	(150)
COMPETITION_CLAUSE	VARCHAR2	(150)
NON_DISCLOSURE_AGREEMENT	VARCHAR2	(150)
CONTRACT_CHANGE_REASON	VARCHAR2	(150)
CONTRACT_CHANGE_DATE	DATE
CONTRACT_EXTENSION_DATE	DATE
CONTRACT_TERMINATION_DATE	DATE
CONTRACT_CANCELLATION_REASON	VARCHAR2	(150)
CONTRACT_CANCELLATION_DATE	DATE
CONTRACT_CANCELLATION_FILE_NUM	VARCHAR2	(150)
CONTRACT_RENEW_STATUS	VARCHAR2	(150)
TYPE_OF_EMPLOYMENT	VARCHAR2	(150)
SUBTYPE_OF_WORK_CONTRACT1	VARCHAR2	(150)
SUBTYPE_OF_WORK_CONTRACT2	VARCHAR2	(150)
LIMITED_DURATION	VARCHAR2	(150)
LIMITED_DURATION_REASON	VARCHAR2	(150)
PART_TIME_CONTRACT	VARCHAR2	(150)
PART_TIME_CONTRACT_TYPE	VARCHAR2	(150)
REMUNERATION_TYPE	VARCHAR2	(150)
TARIFF_CONTRACT	VARCHAR2	(150)
WORK_PLACE	VARCHAR2	(150)
PAY_GRADE	VARCHAR2	(150)
CASE_GROUP	VARCHAR2	(150)
FTE	NUMBER
COLLECTIVE_AGREEMENT	VARCHAR2	(150)
PROBATION_TIME	VARCHAR2	(150)
ALTERNATING_SHIFT_WORK	VARCHAR2	(150)
DAYS_PER_WEEK	VARCHAR2	(150)
SICK_PAY_PERIOD	VARCHAR2	(150)
REGULAR_WORKING_HOURS	VARCHAR2	(150)
PROMOTION_DETAILS	VARCHAR2	(150)
CONTRACT_SUBTYPE	VARCHAR2	(150)
IN_CLASS_TRAINING_HOURS	VARCHAR2	(150)
REMOTE_TRAINING_HOURS	VARCHAR2	(150)
PROPOSED_END_DATE	DATE
PERSON_REPLACED	VARCHAR2	(150)
REPLACEMENT_REASON	VARCHAR2	(150)
EMPLOYEE_TYPE	VARCHAR2	(150)
END_EVENT	VARCHAR2	(150)
PROBATION_PERIOD	NUMBER
PROBATION_PERIOD_UNITS	VARCHAR2	(150)
PROBATION_END_DATE	DATE
SMIC_ADJUSTED_DURATION_DAYS	NUMBER
FIXED_WORKING_TIME	VARCHAR2	(150)
AMOUNT	NUMBER
UNITS	VARCHAR2	(150)
FREQUENCY	VARCHAR2	(150)
CONTRACT_EXPIRY_DATE	DATE
NO_CONTRACT_END_DATE	DATE
LEGAL_REASON_IF_ANY_	VARCHAR2	(150)
EXTRA_INFORMATION_IF_ANY_	VARCHAR2	(150)
DESTINATION_EMPLOYER	VARCHAR2	(150)
EMPLOYER_VAT_NUMBER__NPC	VARCHAR2	(150)
DESTINATION_COUNTRY	VARCHAR2	(150)
CONCATENATED_SEGMENTS	VARCHAR2	(3050)

Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      EMPLOYMENT_STATUS
,      EXPIRY_DATE
,      CONTRACT_CATEGORY
,      FIRST_DATE_WORKED
,      LAST_DATE_WORKED
,      PAYMENT_START_DATE
,      PAYMENT_END_DATE
,      NOTICE_PERIOD
,      NOTICE_PERIOD_UNITS
,      REPLACING_EMPLOYEE
,      CONTRACT_SIGN_OFF_DATE
,      DURATION_OF_PROBATION_LENGTH
,      PROBATION_DURATION_UNIT
,      CONST__PROBATION_END_DATE
,      ACTUAL_PROBATION_END_DATE
,      NOTICE_PERIOD__RESIGN_IN_PROB
,      NOTICE_PERIOD__DISMISS_IN_PROB
,      NOTICE_PERIOD__RESIGNATION
,      NOTICE_PERIOD__DISMISSAL
,      NOTICE_DURATION_UNIT
,      COMPETITION_CLAUSE
,      NON_DISCLOSURE_AGREEMENT
,      CONTRACT_CHANGE_REASON
,      CONTRACT_CHANGE_DATE
,      CONTRACT_EXTENSION_DATE
,      CONTRACT_TERMINATION_DATE
,      CONTRACT_CANCELLATION_REASON
,      CONTRACT_CANCELLATION_DATE
,      CONTRACT_CANCELLATION_FILE_NUM
,      CONTRACT_RENEW_STATUS
,      TYPE_OF_EMPLOYMENT
,      SUBTYPE_OF_WORK_CONTRACT1
,      SUBTYPE_OF_WORK_CONTRACT2
,      LIMITED_DURATION
,      LIMITED_DURATION_REASON
,      PART_TIME_CONTRACT
,      PART_TIME_CONTRACT_TYPE
,      REMUNERATION_TYPE
,      TARIFF_CONTRACT
,      WORK_PLACE
,      PAY_GRADE
,      CASE_GROUP
,      FTE
,      COLLECTIVE_AGREEMENT
,      PROBATION_TIME
,      ALTERNATING_SHIFT_WORK
,      DAYS_PER_WEEK
,      SICK_PAY_PERIOD
,      REGULAR_WORKING_HOURS
,      PROMOTION_DETAILS
,      CONTRACT_SUBTYPE
,      IN_CLASS_TRAINING_HOURS
,      REMOTE_TRAINING_HOURS
,      PROPOSED_END_DATE
,      PERSON_REPLACED
,      REPLACEMENT_REASON
,      EMPLOYEE_TYPE
,      END_EVENT
,      PROBATION_PERIOD
,      PROBATION_PERIOD_UNITS
,      PROBATION_END_DATE
,      SMIC_ADJUSTED_DURATION_DAYS
,      FIXED_WORKING_TIME
,      AMOUNT
,      UNITS
,      FREQUENCY
,      CONTRACT_EXPIRY_DATE
,      NO_CONTRACT_END_DATE
,      LEGAL_REASON_IF_ANY_
,      EXTRA_INFORMATION_IF_ANY_
,      DESTINATION_EMPLOYER
,      EMPLOYER_VAT_NUMBER__NPC
,      DESTINATION_COUNTRY
,      CONCATENATED_SEGMENTS
FROM APPS.PER_CONTRACTS_F_DFV;

Dependencies

[top of page]

APPS.PER_CONTRACTS_F_DFV references the following:

APPS: FND_NUMBER - show dependent code; PER_CONTRACTS_F

APPS.PER_CONTRACTS_F_DFV is not referenced by any database object