select userRequestTypeId from tbl_WRK_userRequestTypes where requestType = 'marketVisitRequest' insert into tbl_WRK_userRequestTypes ( requestType, handlerTemplatePath, ttlDays, requestTypeName ) values ( 'marketVisitRequest', '/mstrcfmod/PCC/workflow/marketVisitRequest', 14, 'Market Visit Request' ) select userRequestTypeId from tbl_WRK_userRequestTypes where requestType = 'marketVisitConfirmation' insert into tbl_WRK_userRequestTypes ( requestType, handlerTemplatePath, ttlDays, requestTypeName ) values ( 'marketVisitConfirmation', '/mstrcfmod/PCC/workflow/marketVisitConfirmation', 14, 'Market Visit Confirmation' )