join xla_ae_headers xah on xae.ae_header_id = xah.ae_header_id ...
, (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 ...