APPS.AP_WEB_DB_UTIL_PKG SQL Statements

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

Line: 28

  	SELECT 	 sysdate
  	INTO	 p_sysDate
  	FROM 	 sys.dual;

Line: 53

  	SELECT 	TO_CHAR(SYSDATE,p_format)
  	INTO 	p_formatted_date
  	FROM 	sys.dual;

Line: 78

	SELECT mod(to_char(to_date(p_date,AP_WEB_INFRASTRUCTURE_PKG.getDateFormat), 'J')+1, 7)
  	INTO   p_day_of_week
  	FROM   sys.dual;

Line: 105

	SELECT	product_version
	INTO 	p_version
	FROM 	fnd_product_installations
	WHERE 	application_id = 200;

Line: 128

	SELECT	application_id
	INTO 	l_application_id
	FROM 	fnd_application
	WHERE 	application_short_name = 'SQLAP';