The following lines contain the word 'select', 'insert', 'update' or 'delete':
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');
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
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;
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
);
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;
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'))
)
);
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;
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');
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;
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;
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;
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');
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;
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;
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;