APPS.ZX_TCM_VALIDATE_EXEMPT_PKG SQL Statements

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

Line: 97

      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;

Line: 117

      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;

Line: 137

      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;