APPS.JL_ZZ_AR_TX_LIB_PKG dependencies on ZX_PRODUCT_OPTIONS

Line 171: l_tax_method zx_product_options.tax_method_code%type;

167: -- Bug 3610797
168: FUNCTION get_tax_method
169: (p_org_id IN NUMBER) RETURN VARCHAR2 IS --Bugfix 2367111
170:
171: l_tax_method zx_product_options.tax_method_code%type;
172: l_org_id NUMBER;
173:
174: CURSOR get_tax_method_csr
175: ( c_org_id NUMBER)

Line 178: FROM zx_product_options_all prod,

174: CURSOR get_tax_method_csr
175: ( c_org_id NUMBER)
176: IS
177: SELECT prod.tax_method_code
178: FROM zx_product_options_all prod,
179: ar_system_parameters_all sys --Bugfix 2367111
180: WHERE prod.application_id = 222
181: AND sys.org_id = prod.org_id
182: AND nvl(sys.org_id,-99) = nvl(c_org_id,-99); --Bugfix 2367111;