Operation Details
Description: To retrieve the organization details using its bankAccountID
Sterotype: ns
SQL
SELECT
  Organisation.organisationID,
  Organisation.name,
  Organisation.taxNumber,
  Organisation.registrationNumber,
  Organisation.addressID,
  Organisation.description,
  Organisation.phoneNumberID,
  Organisation.faxNumberID,
  Organisation.emailAddressID
INTO
  :organisationID,
  :name,
  :taxNumber,
  :registrationNumber,
  :addressID,
  :description,
  :phoneNumberID,
  :faxNumberID,
  :emailAddressID 
FROM
  Organisation,
  OrgBankAccountLink 
WHERE OrgBankAccountLink.bankAccountID = :bankAccountID 
  AND OrgBankAccountLink.organisationID = Organisation.organisationID