APPS.HXT_TIME_SUMMARY dependencies on DUAL

Line 227: FROM dual;

223: l_processing_order HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PROCESSING_ORDER%TYPE;
224:
225: CURSOR next_id_cur IS
226: SELECT hxt_seqno.nextval next_id
227: FROM dual;
228:
229: CURSOR get_ovt_rates_cur IS
230: SELECT eltv.hxt_premium_type,
231: eltv.hxt_premium_amount,

Line 958: FROM SYS.DUAL

954: IF (g_hours<>0) and l_non_exp_elem_count = 0 THEN
955: IF g_TIME_IN IS NULL THEN
956: SELECT '1'
957: INTO error_code
958: FROM SYS.DUAL
959: WHERE EXISTS (SELECT hrw.id
960: FROM hxt_sum_hours_worked hrw, hxt_add_elem_info_f hei
961: WHERE hrw.tim_id = g_TIM_ID
962: AND hrw.date_worked = g_DATE_WORKED

Line 980: FROM SYS.DUAL

976: );
977: ELSE -- g_TIME_IN IS NOT NULL
978: SELECT '1'
979: INTO error_code
980: FROM SYS.DUAL
981: WHERE EXISTS (SELECT hrw.id
982: FROM hxt_sum_hours_worked hrw, hxt_add_elem_info_f hei
983: WHERE hrw.tim_id = g_TIM_ID
984: AND hrw.date_worked = g_DATE_WORKED