Versions Compared

Version Old Version 83 New Version 84
Changes made by

Aleksandra Novokhatnia (Deactivated)

Aleksandra Novokhatnia (Deactivated)

Saved on

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.authentication_methods.phone_number = :($.declaration_request.person.authentication_methods.phone_number)
  AND IL_DB.declaration_requests.status IN ('NEW', 'APPROVED')

...

Code Block
WHERE IL_DB.declaration_requests.data.declaration_request.person.documents.number = :($.declaration_request.person.documents.number)
  AND IL_DB.declaration_requests.data.declaration_request.person.authentication_methods.phone_number = :($.declaration_request.person.authentication_methods.phone_number) 
  AND IL_DB.declaration_requests.status IN ('NEW', 'APPROVED')

...

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.documents.number = :($.declaration_request.person.documents.number)
  AND IL_DB.declaration_requests.status IN ('NEW', 'APPROVED')

...

Code Block
WHERE IL_DB.declaration_requests.data.declaration_request.person.documents.number = :($.declaration_request.person.documents.number)
  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.status IN ('NEW', 'APPROVED')

...