USE [MinovaES_Pertalife_Prod]
GO
/****** Object:  StoredProcedure [dbo].[PHRPYCU0300REG]    Script Date: 25/06/2024 15.20.26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[PHRPYCU0300REG]
AS

SELECT 
	  [StartDate]
      ,[EndDate]
      ,[WageTypeDefinition]
      ,[WTDefinitionDesc]
      ,[CalculationDescription]
      ,[Sequence]
      ,[GrossupSequence]
      ,[WageGroup]
      ,[Type]
      ,CASE 
			WHEN Regular = 'N' THEN 'Y' 
			ELSE Regular
		END AS Regular
      ,[Taxable]
      ,[PreTax]
      ,[Valuation]
      ,[Overwrite]
      ,[IsPesangon]
      ,[Base]
      ,[Percentage]
      ,[MinAmount]
      ,[MaxAmount]
      ,[AmountRangeMsgType]
      ,CASE 
			WHEN Regular = 'N' THEN '5000'
			ELSE TaxSubsidy
		END AS TaxSubsidy --,[TaxSubsidy]
      ,[Prorate1]
      ,[Prorate2]
      ,[Prorate3]
      ,[ProrateType]
      ,[ProrateMethod]
      ,[DebitAcc]
      ,[CreditAcc]
      ,[BudgetAcc]
      ,[IncludeToBudget]
      ,[IncludeToVacancyBudget]
      ,[SPTNo]
      ,[RecapNo]
      ,[IsActive]
      ,[Deduction]
      ,[DeductionPercentage]
      ,[WageTypeGenerated]
      ,[WTGeneratedPercentage]
      ,[WageTypeForeign]
      ,[WTForeignConvType]
      ,[Notes]
      ,[CreateBy]
      ,[CreateDate]
      ,[ChangeBy]
      ,[ChangeDate]
      ,[WTAuthorizationGroup]
FROM PHRPYCU0300