City Tax Calculation Card Query and Overrides

Summary:

We are using the below query to pull city calculation card overrides, this query is fetching only 173 records (earlier the count was ~31K). Is there any alternative way of pulling this Information.

I see pay_allow_overrides_vl (35407) table count less than pay_dir_override_usages_f (384012)

Query:

select count(1)
FROM pay_dir_override_usages_f ou
, pay_allow_overrides_vl ao
, pay_value_definitions_vl vdtl
, pay_dir_card_comp_defs_f cdWHERE cd.base_component_name = 'ORA_HRX_US_WTH_CITY'
--AND ou.context_value1 = NVL(:p_state_ident,ou.context_value1 )
AND ou.dir_card_comp_def_id = cd.dir_card_comp_def_id