The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y'
INTO x_valid_flag
FROM ZX_EXEMPTIONS_V
WHERE EXEMPT_CERTIFICATE_NUMBER = p_tax_exempt_number
AND EXEMPT_REASON_CODE = p_tax_exempt_reason_code
AND nvl(site_use_id,nvl(p_ship_to_org_id, p_invoice_to_org_id)) = nvl(p_ship_to_org_id, p_invoice_to_org_id)
AND nvl(cust_account_id, p_bill_to_cust_account_id) = p_bill_to_cust_account_id
AND nvl(PARTY_SITE_ID,nvl(p_ship_to_party_site_id, p_bill_to_party_site_id))= nvl(p_ship_to_party_site_id,
p_bill_to_party_site_id)
AND party_id = p_bill_to_party_id
AND EXEMPTION_STATUS_CODE = 'PRIMARY'
AND TRUNC(NVL(p_trx_date,sysdate)) BETWEEN TRUNC(EFFECTIVE_FROM)
AND TRUNC(NVL(EFFECTIVE_TO,NVL(p_trx_date,sysdate)))
AND ROWNUM = 1;
SELECT 'Y'
INTO x_valid_flag
FROM ZX_EXEMPTIONS_V
WHERE EXEMPT_CERTIFICATE_NUMBER = p_tax_exempt_number
AND EXEMPT_REASON_CODE = p_tax_exempt_reason_code
AND nvl(site_use_id,nvl(p_ship_to_org_id, p_invoice_to_org_id)) = nvl(p_ship_to_org_id, p_invoice_to_org_id)
AND nvl(cust_account_id, p_bill_to_cust_account_id) = p_bill_to_cust_account_id
AND nvl(PARTY_SITE_ID,nvl(p_ship_to_party_site_id, p_bill_to_party_site_id))= nvl(p_ship_to_party_site_id,
p_bill_to_party_site_id)
AND party_id = p_bill_to_party_id
AND EXEMPTION_STATUS_CODE IN ('PRIMARY', 'MANUAL')
AND TRUNC(NVL(p_trx_date,sysdate)) BETWEEN TRUNC(EFFECTIVE_FROM)
AND TRUNC(NVL(EFFECTIVE_TO,NVL(p_trx_date,sysdate)))
AND ROWNUM = 1;
SELECT 'Y'
INTO x_valid_flag
FROM ZX_EXEMPTIONS_V
WHERE EXEMPT_CERTIFICATE_NUMBER = p_tax_exempt_number
AND EXEMPT_REASON_CODE = p_tax_exempt_reason_code
AND nvl(site_use_id,nvl(p_ship_to_org_id, p_invoice_to_org_id)) = nvl(p_ship_to_org_id, p_invoice_to_org_id)
AND nvl(cust_account_id, p_bill_to_cust_account_id) = p_bill_to_cust_account_id
AND nvl(PARTY_SITE_ID,nvl(p_ship_to_party_site_id, p_bill_to_party_site_id))= nvl(p_ship_to_party_site_id,
p_bill_to_party_site_id)
AND party_id = p_bill_to_party_id
AND EXEMPTION_STATUS_CODE IN ('PRIMARY', 'MANUAL','UNAPPROVED')
AND TRUNC(NVL(p_trx_date,sysdate)) BETWEEN TRUNC(EFFECTIVE_FROM)
AND TRUNC(NVL(EFFECTIVE_TO,NVL(p_trx_date,sysdate)))
AND ROWNUM = 1;