APPS.OKS_QA_DATA_INTEGRITY dependencies on ZX_EXEMPTIONS

Line 2840: FROM zx_exemptions v2

2836: -- fetch a row, raise error
2837: CURSOR old_valid_exemption_csr(l_tax_exemption_id NUMBER, l_start_date DATE)
2838: IS
2839: SELECT v2.exempt_certificate_number
2840: FROM zx_exemptions v2
2841: WHERE (trunc(l_start_date) BETWEEN trunc(v2.EFFECTIVE_FROM)
2842: AND nvl(trunc(v2.EFFECTIVE_TO), trunc(l_start_date)))
2843: AND v2.tax_exemption_id = l_tax_exemption_id;
2844:

Line 2851: FROM zx_exemptions v1

2847:
2848: CURSOR old_exemption_period_csr(l_start_date DATE, l_tax_exemption_id NUMBER, l_trx_date DATE)
2849: IS
2850: SELECT exempt_certificate_number, effective_from, effective_to
2851: FROM zx_exemptions v1
2852: WHERE EXEMPTION_STATUS_CODE IN ('PRIMARY', 'MANUAL', 'UNAPPROVED')
2853: AND v1.tax_exemption_id = l_tax_exemption_id --selected tax_exemption_id from top_line_csr
2854: AND NOT EXISTS(
2855: SELECT 1 FROM zx_exemptions v2

Line 2855: SELECT 1 FROM zx_exemptions v2

2851: FROM zx_exemptions v1
2852: WHERE EXEMPTION_STATUS_CODE IN ('PRIMARY', 'MANUAL', 'UNAPPROVED')
2853: AND v1.tax_exemption_id = l_tax_exemption_id --selected tax_exemption_id from top_line_csr
2854: AND NOT EXISTS(
2855: SELECT 1 FROM zx_exemptions v2
2856: WHERE v2.tax_exemption_id = l_tax_exemption_id
2857: AND trunc(l_trx_date) BETWEEN trunc(v1.EFFECTIVE_FROM) AND nvl(trunc(v1.EFFECTIVE_TO), trunc(l_trx_date ))
2858: )
2859: ;

Line 2868: FROM ZX_EXEMPTIONS

2864: CURSOR old_approved_exemption_csr(l_tax_exempt_id NUMBER)
2865: IS
2866: -- if the sql statement fetches a row, raise error.
2867: SELECT exemption_status_code
2868: FROM ZX_EXEMPTIONS
2869: WHERE exemption_status_code = 'UNAPPROVED'
2870: AND TAX_EXEMPTION_ID = l_tax_exempt_id;
2871:
2872:

Line 2931: FROM zx_exemptions

2927: -- 5/6/2005 --
2928: -- IKON ENHANCEMENT --
2929: CURSOR old_check_tax_exempt_acct(l_tax_exemption_id IN NUMBER ) IS
2930: SELECT cust_account_id
2931: FROM zx_exemptions
2932: WHERE exemption_status_code IN ('PRIMARY', 'MANUAL', 'UNAPPROVED')
2933: AND tax_exemption_id = l_tax_exemption_id; --selected tax_exemption_id from top_line_csr
2934:
2935: /** not needed for new R12 flow bug 5264786

Line 2939: FROM zx_exemptions_v

2935: /** not needed for new R12 flow bug 5264786
2936: CURSOR new_check_tax_exempt_acct(l_tax_exempt_number VARCHAR2,
2937: l_tax_exempt_reason_code VARCHAR2) IS
2938: SELECT cust_account_id
2939: FROM zx_exemptions_v
2940: WHERE EXEMPT_CERTIFICATE_NUMBER = l_tax_exempt_number
2941: AND EXEMPT_REASON_CODE = l_tax_exempt_reason_code
2942: AND exemption_status_code IN ('PRIMARY', 'MANUAL', 'UNAPPROVED');
2943: **/