USP_DATALIST_PROGRAMPRICELIST

Lists all price lists for a program.

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



      CREATE procedure dbo.USP_DATALIST_PROGRAMPRICELIST
      (@CONTEXTID uniqueidentifier)
      as
          set nocount on;

            --declare @PRID uniqueidentifier

         -- select @PRID = PRICELISTID

         -- from dbo.PROGRAM

        --  where ID = @CONTEXTID-->


          select 
            ID,
            NAME
          from
            dbo.PRICELIST
          --where ID = @PRID-->