APPS.HXC_TCD_XML_PKG dependencies on HXC_TIMECARD_SUMMARY

Line 209: FROM hxc_timecard_summary

205: SELECT 'Y' FROM dual
206: WHERE (
207: EXISTS (
208: SELECT 'Y'
209: FROM hxc_timecard_summary
210: WHERE resource_id = p_person_id
211: AND TRUNC(start_time) >= p_period_start_date
212: AND TRUNC(stop_time) < p_period_end_date)
213: AND NOT EXISTS (

Line 215: FROM hxc_timecard_summary

211: AND TRUNC(start_time) >= p_period_start_date
212: AND TRUNC(stop_time) < p_period_end_date)
213: AND NOT EXISTS (
214: SELECT 'Y'
215: FROM hxc_timecard_summary
216: WHERE resource_id = p_person_id
217: AND TRUNC(start_time) > p_period_start_date
218: AND TRUNC(stop_time) <= p_period_end_date)
219: )

Line 268: SELECT start_time INTO l_tc_start_time FROM hxc_timecard_summary WHERE timecard_id = p_timecard_id;

264:
265: -- If a timecard exists, start date will be set to timecard start date
266: IF p_timecard_id IS NOT NULL
267: THEN
268: SELECT start_time INTO l_tc_start_time FROM hxc_timecard_summary WHERE timecard_id = p_timecard_id;
269:
270: l_tc_start_date := l_tc_start_time;
271:
272: END IF;

Line 296: FROM hxc_timecard_summary

292: l_sql := null;
293: -- Bug 8205132
294: -- Added a TRUNC below to avoid the timestamp.
295: l_sql := 'SELECT TRUNC(stop_time) + 1
296: FROM hxc_timecard_summary
297: WHERE resource_id = :1
298: AND TRUNC(start_time) >= :2
299: AND TRUNC(stop_time) < :3';
300:

Line 384: SELECT stop_time INTO l_tc_stop_date FROM hxc_timecard_summary WHERE timecard_id = p_timecard_id;

380: SELECT LEAST(l_pref_end_date,l_tc_end_date,l_period_end_date) INTO l_tc_end_date FROM dual;
381:
382: IF p_timecard_id IS NOT NULL
383: THEN
384: SELECT stop_time INTO l_tc_stop_date FROM hxc_timecard_summary WHERE timecard_id = p_timecard_id;
385:
386: IF l_tc_end_date > l_tc_stop_date
387: THEN
388: l_tc_end_date := l_tc_stop_date;

Line 454: ((SELECT resource_id, timecard_id, approval_status FROM hxc_timecard_summary

450: AND time_building_block_id = tim.timecard_id
451: AND date_to = hr_general.end_of_time
452: ) AS last_update_date
453: FROM HXC_TCD_DETAILS_V v,
454: ((SELECT resource_id, timecard_id, approval_status FROM hxc_timecard_summary
455: WHERE resource_id IN (
456: ';
457: FOR i IN 1..p_person_ids.count
458: LOOP

Line 519: FROM hxc_timecard_summary

515:
516: l_sql := l_sql || ' )
517: AND( EXISTS
518: (SELECT ''Y''
519: FROM hxc_timecard_summary
520: WHERE resource_id = paaf.person_id
521: AND TRUNC(start_time) >= :3
522: AND TRUNC(stop_time) < :4)
523: AND NOT EXISTS

Line 525: FROM hxc_timecard_summary

521: AND TRUNC(start_time) >= :3
522: AND TRUNC(stop_time) < :4)
523: AND NOT EXISTS
524: (SELECT ''Y''
525: FROM hxc_timecard_summary
526: WHERE resource_id = paaf.person_id
527: AND TRUNC(start_time) > :31
528: AND TRUNC(stop_time) <= :41) )
529: AND EXISTS