public String getSqlSelectISOCurrencyDistinctClassCode() {
if (S_sqlSelectISOCurrencyDistinctClassCode == null) {
S_sqlSelectISOCurrencyDistinctClassCode =
"SELECT "
+ "DISTINCT iscy.ClassCode "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..iso_ccy AS iscy ";
}
return (S_sqlSelectISOCurrencyDistinctClassCode);
}
public String getSqlSelectTSecGroupDistinctClassCode() {
if (S_sqlSelectTSecGroupDistinctClassCode == null) {
S_sqlSelectTSecGroupDistinctClassCode =
"SELECT "
+ "DISTINCT tgrp.ClassCode "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..TSecGrp AS tgrp ";
}
return (S_sqlSelectTSecGroupDistinctClassCode);
}
public String getSqlSelectAuditActionDistinctClassCode() {
if (S_sqlSelectAuditActionDistinctClassCode == null) {
S_sqlSelectAuditActionDistinctClassCode =
"SELECT "
+ "DISTINCT audt.ClassCode "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..AuditAction AS audt ";
}
return (S_sqlSelectAuditActionDistinctClassCode);
}
public String getSqlSelectAuditActionBuff() {
if (S_sqlSelectAuditActionBuff == null) {
S_sqlSelectAuditActionBuff =
"SELECT "
+ "audt.auditactionid, "
+ "audt.description, "
+ "audt.revision "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..AuditAction AS audt ";
}
return (S_sqlSelectAuditActionBuff);
}
public String getSqlSelectTSecGroupBuff() {
if (S_sqlSelectTSecGroupBuff == null) {
S_sqlSelectTSecGroupBuff =
"SELECT "
+ "tgrp.tenantid, "
+ "tgrp.tsecgroupid, "
+ "tgrp.name, "
+ "tgrp.isvisible, "
+ "tgrp.revision "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..TSecGrp AS tgrp ";
}
return (S_sqlSelectTSecGroupBuff);
}
public String getSqlSelectISOCurrencyBuff() {
if (S_sqlSelectISOCurrencyBuff == null) {
S_sqlSelectISOCurrencyBuff =
"SELECT "
+ "iscy.id, "
+ "iscy.iso_code, "
+ "iscy.ccy_name, "
+ "iscy.unit_symbol, "
+ "iscy.frac_symbol, "
+ "iscy.precis, "
+ "iscy.revision "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..iso_ccy AS iscy ";
}
return (S_sqlSelectISOCurrencyBuff);
}
