modified delete function in KLP_common file and modified the raw sql query for promotion script