Investigate better way to fetch pipeline for Dependency and License list

Problem to solve

For Dependency and License list pages we need to get the latest pipeline with artifacts of needed type (:dependency_scanning or :license_scanning). With the recent change of dependency_scanning job current way doesn't work correctly (we were fetching just the latest pipeline with needed artifacts, but because dependency scanning analyzer creates multiple jobs, some of them are unfinished and not all artifacts are displayed on the page. That resulted in a recent bug #327955 (closed).

During its refinement it was discovered that for Security Dashboard page we get this pipeline differently. This approach relies on data from the separate table in the database but can't be applied to License List as security artifact types are coupled in this solution.

Proposal

We need to investigate how we can leverage this approach for Dependency and License list pages