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 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 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);
}