DBA Data[Home] [Help]

APPS.FLM_TIMEZONE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 48

      SELECT gmt_deviation_hours
	INTO l_client_offset
	FROM hz_timezones
	WHERE timezone_id = g_client_id;
Line: 53

      SELECT gmt_deviation_hours
	INTO l_server_offset
	FROM hz_timezones
	WHERE timezone_id = g_server_id;
Line: 60

	 SELECT start_time
	   INTO l_start_time
	   FROM wip_lines
	   WHERE organization_id = p_org_id
	   AND (disable_date IS NULL
	     OR disable_date > Sysdate)
	     AND ROWNUM=1
           ORDER BY line_code;