Query: codepipeline_pipelines_for_codecommit_repository

select
  p.arn as codepipeline_pipeline_arn
from
  aws_codecommit_repository r
  cross join aws_codepipeline_pipeline as p
where
  r.arn = $1 and r.account_id = split_part($1, ':', 5) and r.region = split_part($1, ':', 4) and p.stages is not null
  and r.repository_name in (
    select
      jsonb_path_query(p.stages, '$[*].Actions[*].Configuration.RepositoryName')::text
  );