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

VIEW: APPS.PER_PERIODS_OF_SERVICE1_DFV

Object Details
Object Name: PER_PERIODS_OF_SERVICE1_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)
TERMINATION_TYPE VARCHAR2 (150)
DEATH_BENEFIT_TYPE VARCHAR2 (150)
TFN_SUPPLIED_FOR_NON_DEPENDENT VARCHAR2 (150)
TAX_FILE_NUMBER VARCHAR2 (150)
FUTURE_RETIREMENT_DATE DATE

COMPENSATION VARCHAR2 (150)
GOLDEN_HANDSHAKE VARCHAR2 (150)
SALARY_IN_LIEU VARCHAR2 (150)
UNUSED_SICK_LEAVE VARCHAR2 (150)
UNUSED_RDO VARCHAR2 (150)
OTHER VARCHAR2 (150)
NOTIFIED_DATE VARCHAR2 (150)
NOTICE_TYPE VARCHAR2 (150)
DERIVATION_METHOD VARCHAR2 (150)
SALARY VARCHAR2 (150)
NOTICE_PERIOD_MONTHS VARCHAR2 (150)
COUNTER_NOTICE_MONTHS VARCHAR2 (150)
LEAVE_DAYS VARCHAR2 (150)
CURRENCY VARCHAR2 (150)
ROE_REASON VARCHAR2 (150)
ROE_COMMENTS VARCHAR2 (150)
LAST_WORKED DATE

ACCRUED_VACATION VARCHAR2 (150)
VACATION_ACCRUED NUMBER

VACATION_TAKEN NUMBER

VACATION_REMAINING NUMBER

VACATION_ACCRUED_FROM DATE

VACATION_ACCRUED_TO DATE

STARTING_REASON VARCHAR2 (150)
ENDING_REASON VARCHAR2 (150)
QUALIFICATION_LEVEL VARCHAR2 (150)
TYPE_OF_WORK VARCHAR2 (150)
EMPLOYEE_STATUS VARCHAR2 (150)
AFFILIATED_ALSACEMOSELLE_DSS VARCHAR2 (150)
RELATIONSHIP_WITH_MD VARCHAR2 (150)
NOTICE_PERIOD_START_DATE DATE

NOTICE_PERIOD_END_DATE DATE

LAST_DAY_WORKED DATE

FINAL_PAYMENT_SCHEDULE VARCHAR2 (150)
COVERED_BY_SOCIAL_PLAN VARCHAR2 (150)
LAST_FULLTIME_DAY_WORKED DATE

DATE_ATTESTATION_ASSEDIC_RUN DATE

AUTHORISATION_DATE DATE

DATE_OF_DEPARTURE DATE

REASON_FOR_DEPARTURE VARCHAR2 (150)
COUNTRY_RETURNING_TO VARCHAR2 (150)
SECONDED_TO VARCHAR2 (150)
RETURNING_TO_HONG_KONG VARCHAR2 (150)
PROBABLE_RETURN_DATE DATE

NEW_EMPLOYER_NAME_AND_ADDRESS VARCHAR2 (150)
SALARIES_TAX_BORNE_BY_EMPLOYER VARCHAR2 (150)
PF_PRINT_LEAV VARCHAR2 (150)
PF_EFILE_LEAV VARCHAR2 (150)
ECR_LEAV_REAS VARCHAR2 (150)
SS_LEAVING_REASON VARCHAR2 (150)
OLD_TERMINATION_DATE DATE

NEW_TERMINATION_DATE DATE

ABP_REPORTING_PERIOD DATE

HIJRAH_TERMINATION_DATE VARCHAR2 (150)
CONCATENATED_SEGMENTS VARCHAR2 (2295)
Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      TERMINATION_TYPE
,      DEATH_BENEFIT_TYPE
,      TFN_SUPPLIED_FOR_NON_DEPENDENT
,      TAX_FILE_NUMBER
,      FUTURE_RETIREMENT_DATE
,      COMPENSATION
,      GOLDEN_HANDSHAKE
,      SALARY_IN_LIEU
,      UNUSED_SICK_LEAVE
,      UNUSED_RDO
,      OTHER
,      NOTIFIED_DATE
,      NOTICE_TYPE
,      DERIVATION_METHOD
,      SALARY
,      NOTICE_PERIOD_MONTHS
,      COUNTER_NOTICE_MONTHS
,      LEAVE_DAYS
,      CURRENCY
,      ROE_REASON
,      ROE_COMMENTS
,      LAST_WORKED
,      ACCRUED_VACATION
,      VACATION_ACCRUED
,      VACATION_TAKEN
,      VACATION_REMAINING
,      VACATION_ACCRUED_FROM
,      VACATION_ACCRUED_TO
,      STARTING_REASON
,      ENDING_REASON
,      QUALIFICATION_LEVEL
,      TYPE_OF_WORK
,      EMPLOYEE_STATUS
,      AFFILIATED_ALSACEMOSELLE_DSS
,      RELATIONSHIP_WITH_MD
,      NOTICE_PERIOD_START_DATE
,      NOTICE_PERIOD_END_DATE
,      LAST_DAY_WORKED
,      FINAL_PAYMENT_SCHEDULE
,      COVERED_BY_SOCIAL_PLAN
,      LAST_FULLTIME_DAY_WORKED
,      DATE_ATTESTATION_ASSEDIC_RUN
,      AUTHORISATION_DATE
,      DATE_OF_DEPARTURE
,      REASON_FOR_DEPARTURE
,      COUNTRY_RETURNING_TO
,      SECONDED_TO
,      RETURNING_TO_HONG_KONG
,      PROBABLE_RETURN_DATE
,      NEW_EMPLOYER_NAME_AND_ADDRESS
,      SALARIES_TAX_BORNE_BY_EMPLOYER
,      PF_PRINT_LEAV
,      PF_EFILE_LEAV
,      ECR_LEAV_REAS
,      SS_LEAVING_REASON
,      OLD_TERMINATION_DATE
,      NEW_TERMINATION_DATE
,      ABP_REPORTING_PERIOD
,      HIJRAH_TERMINATION_DATE
,      CONCATENATED_SEGMENTS
FROM APPS.PER_PERIODS_OF_SERVICE1_DFV;

Dependencies

[top of page]

APPS.PER_PERIODS_OF_SERVICE1_DFV references the following:

SchemaAPPS
PL/SQL PackageFND_NUMBER - show dependent code
SynonymPER_PERIODS_OF_SERVICE

APPS.PER_PERIODS_OF_SERVICE1_DFV is not referenced by any database object