select acknowledgementDate
from tbl_SSO_ProviderMemberAcknowledgements
where domainOwnerId =
and domainOwnerType =
and provider =
and fspro_userid =
insert into tbl_SSO_ProviderMemberAcknowledgements
( domainOwnerId, domainOwnerType, provider, fspro_userid, acknowledgementDate )
values ( ,
,
,
,
{ fn now() })
select provider
from tbl_SSO_Providers
where providerRole = 'SERVICE'
and options = 'SAML1'
and domainOwnerId =
and domainOwnerType =
select domainOwnerId, domainOwnerType
from tbl_SSO_Providers
where provider =
and providerRole = 'SERVICE'
and options = 'SAML1'
--->
Provider not found