View: HXT_EMP_TIME_INFO_V

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

View Text

SELECT TIM.ID TIM_ID
, TIM.FOR_PERSON_ID
, TIM.TIME_PERIOD_ID
, TPD.START_DATE TIME_PERIOD_START_DATE
, TPD.END_DATE TIME_PERIOD_END_DATE
, TPD.PERIOD_NAME TIME_PERIOD_NAME
, TPD.PERIOD_NUM TIME_PERIOD_NUM
, PER.BUSINESS_GROUP_ID
FROM PER_TIME_PERIODS TPD
, PER_PEOPLE PER
, HXT_TIMECARDS TIM
WHERE TIM.TIME_PERIOD_ID = TPD.TIME_PERIOD_ID
AND PER.PERSON_ID = TIM.FOR_PERSON_ID

Columns