CLIENT SUPPORT » IMFI Bugs

ALTER TRIGGER AfterInsertPHRPA0019AttendanceType

ON hr_md_emp_md0002

AFTER UPDATE

AS

IF (UPDATE(movement_type))

BEGIN

DECLARE @id AS INT

SELECT @id = (SELECT top(1) p.emp_id FROM hr_md_emp_md0002 p INNER JOIN inserted i ON p.emp_id = i.emp_id AND i.movement_type='80')

Exec Rpt_IMFI_HR_PA_ALL_EMPLOYEE_Service @landscape='100',@companycode='1000',@emp_id=@id;

END;