eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.HXT_EMP_TIME_INFO_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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