APPS.ZX_TCM_GET_EXCEPT_PKG dependencies on ZX_SCO_EXCEPTIONS

Line 43: FROM zx_sco_exceptions

39: p_tax_rate_code VARCHAR2,
40: p_tax_jurisdiction_id NUMBER
41: ) IS
42: SELECT tax_exception_id, exception_type_code, rate_modifier
43: FROM zx_sco_exceptions
44: WHERE product_id = p_inventory_item_id
45: -- AND inventory_org_id = p_inventory_organization_id
46: AND classification_type_code IS NULL
47: AND classification_code IS NULL

Line 67: FROM zx_sco_exceptions ex, mtl_categories_b_kfv mc, mtl_category_sets_b mcs,

63: p_inventory_item_id NUMBER,
64: p_inventory_organization_id NUMBER
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

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)