• Home
• org.kuali.ole
• ole-ls-sql
• 1.6.2
• source code
• OLE_PTRN_PAY_STA_T.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.oracle.OLE_PTRN_PAY_STA_T.sql Maven / Gradle / Ivy

TRUNCATE TABLE OLE_PTRN_PAY_STA_T DROP STORAGE
/
INSERT INTO OLE_PTRN_PAY_STA_T (OBJ_ID,PAY_STA_CODE,PAY_STA_ID,PAY_STA_NAME,VER_NBR)
  VALUES ('48ce3815-ad26-42b4-afd4-fe28e0e239c4','PAY_OUTSTN','1','Outstanding',1)
/
INSERT INTO OLE_PTRN_PAY_STA_T (OBJ_ID,PAY_STA_CODE,PAY_STA_ID,PAY_STA_NAME,VER_NBR)
  VALUES ('ba5a4042-3e5a-47a3-8191-76104453feee','PAY_FULL','2','Fully Paid',1)
/
INSERT INTO OLE_PTRN_PAY_STA_T (OBJ_ID,PAY_STA_CODE,PAY_STA_ID,PAY_STA_NAME,VER_NBR)
  VALUES ('ec3def30-31ba-4c4e-8d75-5e17cf970677','PAY_PAR','3','Partially Paid',1)
/
INSERT INTO OLE_PTRN_PAY_STA_T (OBJ_ID,PAY_STA_CODE,PAY_STA_ID,PAY_STA_NAME,VER_NBR)
  VALUES ('dc3def30-31ba-4c4e-8d75-5e17cf970677','PAY_ERR','4','In Error',1)
/
INSERT INTO OLE_PTRN_PAY_STA_T (OBJ_ID,PAY_STA_CODE,PAY_STA_ID,PAY_STA_NAME,VER_NBR)
  VALUES ('1c3def30-31ba-4c4e-8d75-5e17cf970677','PAY_FORGIVEN','5','Forgiven',1)
/
INSERT INTO OLE_PTRN_PAY_STA_T (OBJ_ID,PAY_STA_CODE,PAY_STA_ID,PAY_STA_NAME,VER_NBR)
  VALUES ('2c3def30-31ba-4c4e-8d75-5e17cf970677','PAY_CANCELLED','6','Cancelled',1)
/