APPS.HXC_TCD_XML_PKG dependencies on DUAL

Line 205: SELECT 'Y' FROM dual

201: CURSOR c_chk_tc_exists ( p_person_id IN NUMBER,
202: p_period_start_date IN DATE,
203: p_period_end_date IN DATE)
204: IS
205: SELECT 'Y' FROM dual
206: WHERE (
207: EXISTS (
208: SELECT 'Y'
209: FROM hxc_timecard_summary

Line 380: SELECT LEAST(l_pref_end_date,l_tc_end_date,l_period_end_date) INTO l_tc_end_date FROM dual;

376: and effective_end_date >= g_tc_start_date
377: and primary_flag = 'Y'
378: and assignment_type in ('E','C');
379:
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;