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