• Home
• it.cnr.si.sigla
• sigla-backend
• 6.6.4
• source code
• dwh_getpgmodulofromgae.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_getpgmodulofromgae.fnc Maven / Gradle / Ivy

CREATE OR REPLACE FUNCTION DWH_GETPGMODULOFROMGAE(IN_CDR IN VARCHAR2, IN_GAE VARCHAR2)
  RETURN NUMBER Is
   PG_MODULO_OUT  NUMBER;
Begin
    SELECT PG_PROGETTO
    INTO   PG_MODULO_OUT
    FROM   LINEA_ATTIVITA
    WHERE  CD_CENTRO_RESPONSABILITA = IN_CDR And
           CD_LINEA_ATTIVITA = IN_GAE;
    RETURN PG_MODULO_OUT;
END DWH_GETPGMODULOFROMGAE;
/