public String getSqlSelectTSecGroupDistinctClassCode() {
if (S_sqlSelectTSecGroupDistinctClassCode == null) {
S_sqlSelectTSecGroupDistinctClassCode =
"SELECT "
+ "DISTINCT tgrp.ClassCode "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..TSecGrp AS tgrp ";
}
return (S_sqlSelectTSecGroupDistinctClassCode);
}
public String getSqlSelectSecAppDistinctClassCode() {
if (S_sqlSelectSecAppDistinctClassCode == null) {
S_sqlSelectSecAppDistinctClassCode =
"SELECT "
+ "DISTINCT sapp.ClassCode "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..SecApp AS sapp ";
}
return (S_sqlSelectSecAppDistinctClassCode);
}
public String getSqlSelectTSecGroupBuff() {
if (S_sqlSelectTSecGroupBuff == null) {
S_sqlSelectTSecGroupBuff =
"SELECT "
+ "tgrp.tenantid, "
+ "tgrp.tsecgroupid, "
+ "tgrp.name, "
+ "tgrp.revision "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..TSecGrp AS tgrp ";
}
return (S_sqlSelectTSecGroupBuff);
}
public String getSqlSelectSecAppBuff() {
if (S_sqlSelectSecAppBuff == null) {
S_sqlSelectSecAppBuff =
"SELECT "
+ "sapp.clusterid, "
+ "sapp.secappid, "
+ "sapp.jeemountname, "
+ "sapp.revision "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..SecApp AS sapp ";
}
return (S_sqlSelectSecAppBuff);
}