APPS.AP_AWT_TAX_RATES_PKG SQL Statements

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

Line: 8

	SELECT 	DISTINCT RATE_TYPE
	FROM    AP_AWT_TAX_RATES
	WHERE   TAX_NAME = v_tax_name
	-- For bug2995926
	-- Removing 'CERTIFICATE' and 'EXCEPTION' type in the
	-- validation.
	AND     RATE_TYPE NOT IN ('CERTIFICATE','EXCEPTION');

Line: 19

	SELECT	nvl(Start_date,to_date('01-01-1000','DD-MM-YYYY')),
                nvl(END_DATE,to_date('01-12-3000','DD-MM-YYYY')),
                vendor_id, --BUG 1974076
                vendor_site_id --BUG 1974076
	FROM	AP_AWT_TAX_RATES
	WHERE	TAX_NAME   = v_tax_name
	  AND	RATE_TYPE  = v_rate_type
        GROUP BY nvl(Start_date,to_date('01-01-1000','DD-MM-YYYY')),
                 nvl(END_DATE,to_date('01-12-3000','DD-MM-YYYY')),
                 vendor_id, --BUG 1974076
                 vendor_site_id; --BUG 1974076

Line: 35

	SELECT	NVL(START_AMOUNT,0),
                NVL(END_AMOUNT, 99999999999999), TAX_RATE_ID, TAX_NAME
	FROM 	AP_AWT_TAX_RATES
	WHERE	TAX_NAME      = v_tax_name
          AND	RATE_TYPE     = v_rate_type
          AND   nvl(Start_date,to_date('01-01-1000','DD-MM-YYYY')) = v_start_dt
          AND   nvl(END_DATE,to_date('01-12-3000','DD-MM-YYYY'))   = v_end_dt;

Line: 90

	      SELECT  COUNT(*)
	      INTO    duplicate_check
	      FROM    AP_AWT_TAX_RATES
	      WHERE   TAX_NAME      = X_tax_name
          	AND   RATE_TYPE     = var_rate_type
                AND   NOT (
			   START_AMOUNT IS NULL AND END_AMOUNT IS NULL
			  );

Line: 106

	      SELECT  Count(*)
	      INTO num_duplicate
   	      FROM    AP_AWT_TAX_RATES
	      WHERE   TAX_NAME      = X_tax_name
 	        AND   RATE_TYPE     = var_rate_type
                AND   nvl(start_date,to_date('01-01-1000','DD-MM-YYYY'))
		      IN ( Select nvl(start_date,to_date('01-01-1000','DD-MM-YYYY'))
			   FROM ap_awt_tax_rates
			   WHERE TAX_NAME = X_tax_name /* BUG 1666209  */
		           AND RATE_TYPE = var_rate_type -- BUG 1974076
			   GROUP BY nvl(start_date,to_date('01-01-1000','DD-MM-YYYY')),
				     nvl(end_date,to_date('31-12-3000','DD-MM-YYYY'))
			   HAVING count(*)>1
			   AND nvl(end_date,to_date('31-12-3000','DD-MM-YYYY')) =
			       nvl(ap_awt_tax_rates.end_date,
					    to_date('31-12-3000','DD-MM-YYYY'))
                         )
	      ORDER BY start_date, end_date;

Line: 146

	      SELECT  COUNT(*)
              INTO    var_check
   	      FROM    AP_AWT_TAX_RATES
	      WHERE   TAX_NAME      = X_tax_name
          	AND   RATE_TYPE     = var_rate_type
                AND NOT (

                       nvl(START_DATE,to_date('01-01-1000','DD-MM-YYYY')) = var_start_dt
                       AND
                       nvl(END_DATE,to_date('01-12-3000','DD-MM-YYYY')) = var_end_dt

                     ) -- current cursor row should not be counted

                AND  ( (

                        var_start_dt >= nvl(START_DATE,to_date('01-01-1000','DD-MM-YYYY'))
                        AND
		        var_start_dt <= nvl(END_DATE,to_date('01-12-3000','DD-MM-YYYY'))

                       )
		       OR
		       (

                        var_end_dt >= nvl(START_DATE,to_date('01-01-1000','DD-MM-YYYY'))
                        AND
                 	var_end_dt <= nvl(END_DATE,to_date('01-12-2999','DD-MM-YYYY'))

 		       )
                     );

Line: 186

	      SELECT  COUNT(*)
              INTO    var_check
   	      FROM    AP_AWT_TAX_RATES
	      WHERE   TAX_NAME      = X_tax_name
          	AND   RATE_TYPE     = var_rate_type
                AND   nvl(START_DATE,to_date('01-01-1000','DD-MM-YYYY'))
                                                               = var_start_dt
                AND   nvl(END_DATE,to_date('01-12-2999','DD-MM-YYYY'))
                                                               = var_end_dt
	  	AND 	((var_start   >= START_AMOUNT  AND
			 var_start    < END_AMOUNT)
			OR
			(var_end      >  START_AMOUNT  AND
                 	var_end      <= END_AMOUNT))
		AND   TAX_RATE_ID   <> var_tax_id;

Line: 233

	SELECT 	RATE_TYPE
	FROM    AP_AWT_TAX_RATES
	WHERE   TAX_NAME = v_tax_name
	-- For bug 2995926
	-- Removing 'CERTIFICATE' and 'EXCEPTION' type in the
	-- validation.
	AND     RATE_TYPE NOT IN ('CERTIFICATE','EXCEPTION');

Line: 244

	SELECT	nvl(Start_date,to_date('01-01-1000','DD-MM-YYYY')), nvl(END_DATE,to_date('01-12-1000','DD-MM-YYYY'))
	FROM	AP_AWT_TAX_RATES
	WHERE	TAX_NAME   = v_tax_name
	  AND	RATE_TYPE  = v_rate_type;

Line: 253

	SELECT 	START_AMOUNT
	FROM	AP_AWT_TAX_RATES
        WHERE 	TAX_NAME      = v_tax_name
          AND	RATE_TYPE     = v_rate_type
          AND	nvl(START_DATE,to_date('01-01-1000','DD-MM-YYYY'))    = v_start_dt
          AND	nvl(END_DATE,to_date('01-12-2999','DD-MM-YYYY'))      = v_end_dt
 	  AND   START_AMOUNT  <> 0;

Line: 291

		SELECT  COUNT(*)
		INTO	var_check
		FROM 	AP_AWT_TAX_RATES
		WHERE 	TAX_NAME      = X_tax_name
       		  AND	RATE_TYPE     = var_rate_type
          	  AND	nvl(START_DATE,to_date('01-01-1000','DD-MM-YYYY'))    = var_start_dt
       		  AND	nvl(END_DATE,to_date('01-12-2999','DD-MM-YYYY'))      = var_end_dt
		  AND	END_AMOUNT    = var_start;

Line: 327

	SELECT 	RATE_TYPE
	FROM    AP_AWT_TAX_RATES
	WHERE   TAX_NAME = v_tax_name
	-- For Bug 2995926
	-- Removing 'CERTIFICATE' and 'EXCEPTION' type in the
	-- validation.
	AND     RATE_TYPE NOT IN ('CERTIFICATE','EXCEPTION');

Line: 338

	SELECT	nvl(START_DATE,to_date('01-01-1000','DD-MM-YYYY')), nvl(END_DATE,to_date('01-12-2999','DD-MM-YYYY'))
	FROM	AP_AWT_TAX_RATES
	WHERE	TAX_NAME   = v_tax_name
	  AND	RATE_TYPE  = v_rate_type;

Line: 367

  	   SELECT 	START_AMOUNT
   	   INTO		var_start
    	   FROM		AP_AWT_TAX_RATES
    	   WHERE	TAX_NAME      = X_tax_name
             AND	RATE_TYPE     = var_rate_type
             AND	nvl(START_DATE,to_date('01-01-1000','DD-MM-YYYY'))    = var_start_dt
             AND	nvl(END_DATE,to_date('01-12-2999','DD-MM-YYYY'))      = var_end_dt
	     AND  	END_AMOUNT IS NULL;

Line: 376

		SELECT  MAX(END_AMOUNT)
		INTO	var_max_end
		FROM 	AP_AWT_TAX_RATES
		WHERE	TAX_NAME      = X_tax_name
      		  AND	RATE_TYPE     = var_rate_type
          	  AND	nvl(START_DATE,to_date('01-01-1000','DD-MM-YYYY'))    = var_start_dt
                  AND	nvl(END_DATE,to_date('01-12-2999','DD-MM-YYYY'))      = var_end_dt;