VIEW: APPS.HR_H2PI_PERIODS_OF_SERVICE_V

Source

View Text - Preformatted

SELECT pps.last_update_date, pps.business_group_id, pps.period_of_service_id, pps.person_id, pps.date_start, pps.actual_termination_date, pps.final_process_date, pps.last_standard_process_date, pps.leaving_reason, pps.attribute_category, pps.attribute1, pps.attribute2, pps.attribute3, pps.attribute4, pps.attribute5, pps.attribute6, pps.attribute7, pps.attribute10, pps.attribute11, pps.attribute12, pps.attribute13, pps.attribute14, pps.attribute15, pps.attribute16, pps.attribute17, pps.attribute18, pps.attribute19, pps.attribute20 from per_periods_of_service pps WHERE EXISTS ( select pp.person_id from hr_h2pi_employees_v pp where pp.person_id = pps.person_id)

View Text - HTML Formatted

SELECT PPS.LAST_UPDATE_DATE
, PPS.BUSINESS_GROUP_ID
, PPS.PERIOD_OF_SERVICE_ID
, PPS.PERSON_ID
, PPS.DATE_START
, PPS.ACTUAL_TERMINATION_DATE
, PPS.FINAL_PROCESS_DATE
, PPS.LAST_STANDARD_PROCESS_DATE
, PPS.LEAVING_REASON
, PPS.ATTRIBUTE_CATEGORY
, PPS.ATTRIBUTE1
, PPS.ATTRIBUTE2
, PPS.ATTRIBUTE3
, PPS.ATTRIBUTE4
, PPS.ATTRIBUTE5
, PPS.ATTRIBUTE6
, PPS.ATTRIBUTE7
, PPS.ATTRIBUTE10
, PPS.ATTRIBUTE11
, PPS.ATTRIBUTE12
, PPS.ATTRIBUTE13
, PPS.ATTRIBUTE14
, PPS.ATTRIBUTE15
, PPS.ATTRIBUTE16
, PPS.ATTRIBUTE17
, PPS.ATTRIBUTE18
, PPS.ATTRIBUTE19
, PPS.ATTRIBUTE20
FROM PER_PERIODS_OF_SERVICE PPS
WHERE EXISTS ( SELECT PP.PERSON_ID
FROM HR_H2PI_EMPLOYEES_V PP
WHERE PP.PERSON_ID = PPS.PERSON_ID)