[Home] [Help] [Dependency Information]

VIEW: APPS.PER_PERIODS_OF_SERVICE1_DFV

Object Details

[View Source]

Columns

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
,      FUTURE_RETIREMENT_DATE
,      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
,      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

FND_NUMBER - show dependent code

PER_PERIODS_OF_SERVICE

PUBLIC

PER_PERIODS_OF_SERVICE1_DFV