View: HXT_TIMECARDS_PER_FMV

Product:	HXT - Time and Labor
Description:
Implementation/DBA Data:	APPS.HXT_TIMECARDS_PER_FMV

View Text

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

Columns