APPS.ZX_TCM_GET_EXCEPT_PKG dependencies on ZX_FC_TYPES_B

Line 69: zx_fc_types_b fc, zx_fc_types_reg_assoc fcreg

65: ) IS
66: SELECT ex.tax_exception_id, ex.exception_type_code, ex.rate_modifier
67: FROM zx_sco_exceptions ex, mtl_categories_b_kfv mc, mtl_category_sets_b mcs,
68: fnd_id_flex_structures_vl fifs, mtl_item_categories mic,
69: zx_fc_types_b fc, zx_fc_types_reg_assoc fcreg
70: WHERE ex.product_id IS NULL
71: AND ex.tax_regime_code = p_tax_regime_code
72: AND (ex.tax = p_tax or ex.tax is null)
73: AND (ex.tax_status_code = p_tax_status_code or ex.tax_status_code is null)

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

102: p_tax_rate_code VARCHAR2,
103: p_tax_jurisdiction_id NUMBER
104: ) IS
105: SELECT tax_exception_id, exception_type_code, rate_modifier
106: FROM zx_sco_exceptions ex, zx_fc_types_b fct, zx_fc_types_reg_assoc fcreg, zx_fc_codes_b fcc
107: WHERE ex.tax_regime_code = p_tax_regime_code
108: AND (ex.tax = p_tax or ex.tax is null)
109: AND (ex.tax_status_code = p_tax_status_code or ex.tax_status_code is null)
110: AND (ex.tax_rate_code = p_tax_rate_code or ex.tax_rate_code is null)