public String getSqlSelectServiceTypeDistinctClassCode() {
if (S_sqlSelectServiceTypeDistinctClassCode == null) {
S_sqlSelectServiceTypeDistinctClassCode =
"SELECT "
+ "DISTINCT svct.ClassCode "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..SvcType AS svct ";
}
return (S_sqlSelectServiceTypeDistinctClassCode);
}
public String getSqlSelectServiceTypeBuff() {
if (S_sqlSelectServiceTypeBuff == null) {
S_sqlSelectServiceTypeBuff =
"SELECT "
+ "svct.servicetypeid, "
+ "svct.description, "
+ "svct.revision "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..SvcType AS svct ";
}
return (S_sqlSelectServiceTypeBuff);
}