[dbo].[GetProviderTransactionInformation]

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@inStorageId	int	4
@inInstrumentId	int	4

Type	Action	Owning Principal
Grant	Execute	MssExec

SQL Script

/**
*
* Maintains the provider's payment info needed for subsequent recurring billings for a given
* storage and plastic instrument record that may be needed for each subsequent billing that
* is charging the same plastic instrument (credit card).
*
*/
create procedure [dbo].[GetProviderTransactionInformation]
    @inStorageId int,
    @inInstrumentId int
as
set nocount on;

select
    StorageId = StoragePaymentTransactionTracking.StorageFID,
    InstrumentId = StoragePaymentTransactionTracking.InstrumentFID,
    FirstTransactionId = StoragePaymentTransactionTracking.FirstTransactionID,
    LastTransactionId = StoragePaymentTransactionTracking.LastTransactionID
from StoragePaymentTransactionTracking
where StoragePaymentTransactionTracking.StorageFID = @inStorageId and
    StoragePaymentTransactionTracking.InstrumentFID = @inInstrumentId
GO
GRANT EXECUTE ON  [dbo].[GetProviderTransactionInformation] TO [MssExec]
GO