• Home
• it.cnr.si.sigla
• sigla-backend
• 6.6.4
• source code
• dwh_getcdraccentrfromidclass.fnc

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

expsigladb.Function.dwh_getcdraccentrfromidclass.fnc Maven / Gradle / Ivy

CREATE OR REPLACE FUNCTION Dwh_GetCdrAccentrfromIDClass(ID_CLASS_IN IN NUMBER)
  RETURN VARCHAR2 IS
    CD_CDR CDR.CD_CENTRO_RESPONSABILITA%TYPE;
BEGIN
    SELECT CDR_ACCENTRATORE
    INTO CD_CDR
    FROM CLASSIFICAZIONE_VOCI
    WHERE ID_CLASSIFICAZIONE = ID_CLASS_IN;
    RETURN CD_CDR;
END Dwh_GetCdrAccentrfromIDClass;
/