APPS.OKS_QA_DATA_INTEGRITY dependencies on ZX_EXEMPTIONS

Line 2909: FROM zx_exemptions v2

2905: -- fetch a row, raise error
2906: CURSOR old_valid_exemption_csr(l_tax_exemption_id NUMBER, l_start_date DATE)
2907: IS
2908: SELECT v2.exempt_certificate_number
2909: FROM zx_exemptions v2
2910: WHERE (trunc(l_start_date) BETWEEN trunc(v2.EFFECTIVE_FROM)
2911: AND nvl(trunc(v2.EFFECTIVE_TO), trunc(l_start_date)))
2912: AND v2.tax_exemption_id = l_tax_exemption_id;
2913:

Line 2920: FROM zx_exemptions v1

2916:
2917: CURSOR old_exemption_period_csr(l_start_date DATE, l_tax_exemption_id NUMBER, l_trx_date DATE)
2918: IS
2919: SELECT exempt_certificate_number, effective_from, effective_to
2920: FROM zx_exemptions v1
2921: WHERE EXEMPTION_STATUS_CODE IN ('PRIMARY', 'MANUAL', 'UNAPPROVED')
2922: AND v1.tax_exemption_id = l_tax_exemption_id --selected tax_exemption_id from top_line_csr
2923: AND NOT EXISTS(
2924: SELECT 1 FROM zx_exemptions v2

Line 2924: SELECT 1 FROM zx_exemptions v2

2920: FROM zx_exemptions v1
2921: WHERE EXEMPTION_STATUS_CODE IN ('PRIMARY', 'MANUAL', 'UNAPPROVED')
2922: AND v1.tax_exemption_id = l_tax_exemption_id --selected tax_exemption_id from top_line_csr
2923: AND NOT EXISTS(
2924: SELECT 1 FROM zx_exemptions v2
2925: WHERE v2.tax_exemption_id = l_tax_exemption_id
2926: AND trunc(l_trx_date) BETWEEN trunc(v1.EFFECTIVE_FROM) AND nvl(trunc(v1.EFFECTIVE_TO), trunc(l_trx_date ))
2927: )
2928: ;

Line 2937: FROM ZX_EXEMPTIONS

2933: CURSOR old_approved_exemption_csr(l_tax_exempt_id NUMBER)
2934: IS
2935: -- if the sql statement fetches a row, raise error.
2936: SELECT exemption_status_code
2937: FROM ZX_EXEMPTIONS
2938: WHERE exemption_status_code = 'UNAPPROVED'
2939: AND TAX_EXEMPTION_ID = l_tax_exempt_id;
2940:
2941:

Line 3000: FROM zx_exemptions

2996: -- 5/6/2005 --
2997: -- IKON ENHANCEMENT --
2998: CURSOR old_check_tax_exempt_acct(l_tax_exemption_id IN NUMBER ) IS
2999: SELECT cust_account_id
3000: FROM zx_exemptions
3001: WHERE exemption_status_code IN ('PRIMARY', 'MANUAL', 'UNAPPROVED')
3002: AND tax_exemption_id = l_tax_exemption_id; --selected tax_exemption_id from top_line_csr
3003:
3004: /** not needed for new R12 flow bug 5264786

Line 3008: FROM zx_exemptions_v

3004: /** not needed for new R12 flow bug 5264786
3005: CURSOR new_check_tax_exempt_acct(l_tax_exempt_number VARCHAR2,
3006: l_tax_exempt_reason_code VARCHAR2) IS
3007: SELECT cust_account_id
3008: FROM zx_exemptions_v
3009: WHERE EXEMPT_CERTIFICATE_NUMBER = l_tax_exempt_number
3010: AND EXEMPT_REASON_CODE = l_tax_exempt_reason_code
3011: AND exemption_status_code IN ('PRIMARY', 'MANUAL', 'UNAPPROVED');
3012: **/