APPS.OKS_QA_DATA_INTEGRITY dependencies on ZX_PRODUCT_OPTIONS_ALL

Line 724: FROM zx_product_options_all

720: WHERE id = p_chr_id;
721:
722: CURSOR TAX_METHOD_CUR(p_org_id NUMBER) IS
723: SELECT tax_method_code
724: FROM zx_product_options_all
725: WHERE org_id = p_org_id
726: AND application_id = 222;
727:
728:

Line 730: l_tax_method zx_product_options_all.tax_method_code%TYPE;

726: AND application_id = 222;
727:
728:
729: l_org_id NUMBER;
730: l_tax_method zx_product_options_all.tax_method_code%TYPE;
731: l_inv_trx_type oks_k_headers_b.inv_trx_type%TYPE;
732: l_api_name CONSTANT VARCHAR2(30) := 'Check_Inv_Trx';
733: l_mod_name VARCHAR2(256) := G_APP_NAME || '.PLSQL.' || G_PKG_NAME || '.' || l_api_name;
734: