If ('protection provider'.'reporting agent identifier' = 'counterparty'.'reporting agent identifier' and
'protection provider'.'counterparty role' = "protection provider" and
'protection provider'.'counterparty identifier' = 'counterparty'.'counterparty identifier' and
'protection provider'.'reporting reference date' = 'counterparty'.'reporting reference date' and
'counterparty'.'legal entity indicator' = "legal entity" and
'counterparty'.'reporting agent identifier' = 'legal entity'.'reporting agent identifier' and
'counterparty'.'counterparty identifier' = 'legal entity'.'counterparty identifier' and
'counterparty'.'reporting reference date' = 'legal entity'.'reporting reference date' and
'legal entity'.'resident legal entity indicator' = "foreign legal entity" and
'legal entity'.'reporting agent identifier' = 'foreign legal entity'.'reporting agent identifier' and
'legal entity'.'counterparty identifier' = 'foreign legal entity'.'counterparty identifier' and
'legal entity'.'reporting reference date' = 'foreign legal entity'.'reporting reference date' and
'foreign legal entity'.'foreign legal entity in reporting member state indicator' = "foreign legal entity in reporting member state")
Then
'protection provider'.'ultimate parent undertaking' <> Null
|