public String getSqlSelectISOCountryCurrencyDistinctClassCode() {
if (S_sqlSelectISOCountryCurrencyDistinctClassCode == null) {
S_sqlSelectISOCountryCurrencyDistinctClassCode =
"SELECT "
+ "DISTINCT iccy.ClassCode "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ ".iso_cntryccy AS iccy ";
}
return (S_sqlSelectISOCountryCurrencyDistinctClassCode);
}
public String getSqlSelectISOTimezoneDistinctClassCode() {
if (S_sqlSelectISOTimezoneDistinctClassCode == null) {
S_sqlSelectISOTimezoneDistinctClassCode =
"SELECT "
+ "DISTINCT itzn.ClassCode "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ ".ISOTz AS itzn ";
}
return (S_sqlSelectISOTimezoneDistinctClassCode);
}
public String getSqlSelectISOCountryCurrencyBuff() {
if (S_sqlSelectISOCountryCurrencyBuff == null) {
S_sqlSelectISOCountryCurrencyBuff =
"SELECT "
+ "iccy.ISOCountryId, "
+ "iccy.ISOCurrencyId, "
+ "iccy.Revision "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ ".iso_cntryccy AS iccy ";
}
return (S_sqlSelectISOCountryCurrencyBuff);
}
public String getSqlSelectISOTimezoneBuff() {
if (S_sqlSelectISOTimezoneBuff == null) {
S_sqlSelectISOTimezoneBuff =
"SELECT "
+ "itzn.ISOTimezoneId, "
+ "itzn.Iso8601, "
+ "itzn.TZName, "
+ "itzn.TZHourOffset, "
+ "itzn.TZMinOffset, "
+ "itzn.Description, "
+ "itzn.Visible, "
+ "itzn.Revision "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ ".ISOTz AS itzn ";
}
return (S_sqlSelectISOTimezoneBuff);
}