APPS.GMO_DVC_INTG_PVT dependencies on DUAL

Line 693: select sysdate into l_request_start_date from dual;

689: if (l_subinventory is null or length(l_subinventory) = 0) then
690: raise l_device_subinv_err;
691: end if;
692:
693: select sysdate into l_request_start_date from dual;
694:
695:
696: DEVICE_REQUEST
697: (

Line 749: select sysdate into l_request_current_date from dual;

745: -- we will loop till the response is recevied or timeout (based on profile) has reached.
746:
747: WHILE NOT L_DEVICE_REQUEST_END LOOP
748:
749: select sysdate into l_request_current_date from dual;
750: l_request_exec_time := (l_request_current_date - l_request_start_date)*24*60*60;
751:
752: select RESPONSE_STATUS into l_response_status from gmo_device_requests_t where request_id = l_request_id;
753: