DBA Data[Home] [Help]

APPS.HXC_SUPERVISOR_DASHBOARD dependencies on HXC_TIMECARD_SUMMARY

Line 155: hxc_timecard_summary tim, hxc_temp_tcd temp

151: NULL,LEAD(tim.start_time,1,NULL) over (partition by tim.resource_id Order by tim.stop_time) -1),
152: tim.approval_status
153:
154: FROM
155: hxc_timecard_summary tim, hxc_temp_tcd temp
156: WHERE tim.resource_id = temp.resource_id
157: tim.stop_time >= temp.start_time
158: and tim.start_time <= temp.stop_time';
159:

Line 212: FROM hxc_timecard_summary tim

208: , decode (temp.period_exist, 'T'
209: , 'P', temp.period_exist)
210: , temp.start_time
211: , temp.stop_time
212: FROM hxc_timecard_summary tim
213: , hxc_temp_tcd temp
214: WHERE tim.stop_time >= temp.start_time
215: AND tim.start_time <= temp.stop_time
216: AND temp.resource_id = tim.resource_id