, (select count(psrra.rule_id) from pa.pa_segment_rule_pairings_all psrra where psrra.rule_id = pr.rule_id) assigned_count from pa.pa_rules pr join applsys.fnd_user ...