DBA Data[Home] [Help]

APPS.ZX_TCM_GET_EXCEPT_PKG dependencies on ZX_FC_CODES_B

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)