Paul-Gallagher

--  is dependent on cpn_fare_haul_cd, fare_rule_cd and doc_cpn
SELECT c.task_nm, c.refresh_freq_cd, d.task_id, d.dependent_on_task_id, t.*
  FROM ah_task_control c  
  JOIN ah_dependency_control d 
    ON c.task_nm LIKE '%FARE_%_BASIC_IND_%' 
   AND c.task_id = d.task_id 
   AND d.exp_ts > CURRENT_DATE
  JOIN ah_task_control t  
    ON t.task_id = d.dependent_on_task_id
  ;