PLSQL code used in NECC applications