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
  );