APPS.IGS_AS_VAL_VEA SQL Statements

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

Line: 31

  		SELECT 	'X'
  		FROM	IGS_CO_ADDR_TYPE
  		WHERE	addr_type			= p_addr_type;

Line: 35

  		SELECT	vea.start_dt,
  			vea.end_dt
  		FROM	IGS_GR_VENUE_ADDR	vea
  		WHERE	vea.correspondence_ind	= 'Y'		AND
  			vea.addr_type		<> p_addr_type	AND
  			vea.venue_cd		= p_venue_cd;

Line: 140

  	-- Validate that the IGS_GR_VENUE_ADDR record being created or updated does not
  	-- overlap with an existing address record of the same type for the IGS_GR_VENUE.
  DECLARE
  	v_start_dt	IGS_GR_VENUE_ADDR.start_dt%TYPE;

Line: 147

  		SELECT  IGS_GR_VENUE_ADDR.start_dt,
                NVL(IGS_GR_VENUE_ADDR.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
  		FROM	IGS_GR_VENUE_ADDR
  		WHERE	venue_cd	= p_venue_cd  AND
  			addr_type	= p_addr_type AND
  			start_dt	<> p_start_dt;