APPS.HXT_TIME_SUMMARY dependencies on DUAL

Line 1395: FROM dual;

1391: l_processing_order HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PROCESSING_ORDER%TYPE;
1392:
1393: CURSOR next_id_cur IS
1394: SELECT hxt_seqno.nextval next_id
1395: FROM dual;
1396:
1397: CURSOR get_ovt_rates_cur IS
1398: SELECT eltv.hxt_premium_type,
1399: eltv.hxt_premium_amount,

Line 2234: FROM SYS.DUAL

2230: IF (g_hours<>0) and l_non_exp_elem_count = 0 THEN
2231: IF g_TIME_IN IS NULL THEN
2232: SELECT '1'
2233: INTO error_code
2234: FROM SYS.DUAL
2235: WHERE EXISTS (SELECT hrw.id
2236: FROM hxt_sum_hours_worked hrw, hxt_add_elem_info_f hei
2237: WHERE hrw.tim_id = g_TIM_ID
2238: AND hrw.date_worked = g_DATE_WORKED

Line 2256: FROM SYS.DUAL

2252: );
2253: ELSE -- g_TIME_IN IS NOT NULL
2254: SELECT '1'
2255: INTO error_code
2256: FROM SYS.DUAL
2257: WHERE EXISTS (SELECT hrw.id
2258: FROM hxt_sum_hours_worked hrw, hxt_add_elem_info_f hei
2259: WHERE hrw.tim_id = g_TIM_ID
2260: AND hrw.date_worked = g_DATE_WORKED