Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
WHERE IL_DB.declaration_requests.data.declaration_request.person.tax_id = :($.declaration_request.person.tax_id)
  AND IL_DB.declaration_requests.data.declaration_request.person.first_name = :($.declaration_request.person.first_name)
  AND IL_DB.declaration_requests.data.declaration_request.person.last_name = :($.declaration_request.person.last_name)  
  AND IL_DB.declaration_requests.data.declaration_request.person.second_name = :($.declaration_request.person.second_name)
  AND IL_DB.declaration_requests.data.declaration_request.legal_entity_id = :($.declaration_request.legal_entity_id)
  AND IL_DB.declaration_requests.status IN ('NEW', 'APPROVED')

...