APPS.ZX_TCM_GET_EXCEPT_PKG dependencies on ZX_FC_CODES_B

Line 148: FROM zx_sco_exceptions ex, zx_fc_types_b fct, zx_fc_types_reg_assoc fcreg, zx_fc_codes_b fcc

144: p_tax_rate_code VARCHAR2,
145: p_tax_jurisdiction_id NUMBER
146: ) IS
147: SELECT tax_exception_id, exception_type_code, rate_modifier
148: FROM zx_sco_exceptions ex, zx_fc_types_b fct, zx_fc_types_reg_assoc fcreg, zx_fc_codes_b fcc
149: WHERE ex.tax_regime_code = p_tax_regime_code
150: AND (ex.tax = p_tax or ex.tax is null)
151: AND (ex.tax_status_code = p_tax_status_code or ex.tax_status_code is null)
152: AND (ex.tax_rate_code = p_tax_rate_code or ex.tax_rate_code is null)