APPS.WMS_DATECHECK_PVT SQL Statements

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

Line: 61

	SELECT calendar_code, calendar_exception_set_id
	FROM MTL_PARAMETERS
	WHERE organization_id = org_id;

Line: 67

	SELECT shift_num
	FROM BOM_SHIFT_DATES
	WHERE calendar_code = cal_code AND
	      exception_set_id = nvl(except_set, -1) AND
	      shift_date = cur_date AND
	      shift_num NOT IN (SELECT shift_num
			FROM BOM_SHIFT_TIMES
			WHERE calendar_code = cal_code AND
	     		cur_seconds not between FROM_TIME and TO_TIME) AND
	      seq_num IS NOT NULL;

Line: 79

	SELECT seq_num
	FROM BOM_CAL_WEEK_START_DATES
	WHERE calendar_code = cal_code AND
	      exception_set_id = nvl(except_set, -1) AND
	      cur_date BETWEEN week_start_date AND next_date;

Line: 87

	SELECT period_sequence_num
	FROM BOM_PERIOD_START_DATES
	WHERE calendar_code = cal_code AND
	      exception_set_id = nvl(except_set, -1) AND
	      cur_date between period_start_date and next_date;

Line: 94

	SELECT period_num
	FROM org_acct_periods
	WHERE organization_id = org_id
	AND cur_date BETWEEN period_start_date AND
			     schedule_close_date;

Line: 101

	SELECT period_set_name
	FROM org_acct_periods
	WHERE organization_id = org_id;

Line: 106

	SELECT quarter_num
	FROM gl_periods
	WHERE period_set_name = set_name AND
	      cur_date BETWEEN quarter_start_date AND
			       add_months(quarter_start_date, 3);

Line: 174

	--shifts can overlap, so select can return multiple rows
	WHILE current_shifts%FOUND LOOP
		ret_val := Check_Between(cur_val, from_val, to_val);

Line: 271

	SELECT sysdate
	FROM DUAL;