[workflows] Run workflow when affected by PR

[DevSecNinja]

For all pipelines without a PR trigger, ensure that when a PR happens on the pipeline or any references scripts, the affected pipeline runs.