VIEW: APPS.HXT_TIMECARDS_PER_FMV

Source

View Text - Preformatted

SELECT ptp.end_date, per.full_name, per.employee_number, per.business_group_id, tim.id tim_id, tim.batch_id from per_people_f per, per_time_periods ptp, hxt_timecards tim WHERE tim.for_person_id = per.person_id and tim.time_period_id = ptp.time_period_id and ptp.end_date between per.effective_start_date and per.effective_end_date

View Text - HTML Formatted

SELECT PTP.END_DATE
, PER.FULL_NAME
, PER.EMPLOYEE_NUMBER
, PER.BUSINESS_GROUP_ID
, TIM.ID TIM_ID
, TIM.BATCH_ID
FROM PER_PEOPLE_F PER
, PER_TIME_PERIODS PTP
, HXT_TIMECARDS TIM
WHERE TIM.FOR_PERSON_ID = PER.PERSON_ID
AND TIM.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
AND PTP.END_DATE BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE