SELECT
ServiceSupplier.primaryAlternateID,
ServiceSupplier.concernRoleID,
ServiceSupplier.name,
ConcernRole.sensitivity,
city.elementValue,
addressLine1.elementValue
INTO
:primaryAlternateID,
:concernRoleID,
:name,
:sensitivity,
:city,
:addressLine1
FROM
ConcernRole,
ServiceSupplier,
AddressElement city,
AddressElement addressLine1
WHERE ServiceSupplier.concernRoleID = ConcernRole.concernRoleID
AND
(
city.addressID = ConcernRole.primaryAddressID
AND city.elementType = :cityType
)
AND
(
addressLine1.addressID = ConcernRole.primaryAddressID
AND addressLine1.elementType = :addressLine1Type
)
|