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

CREATE OR REPLACE function DWH_getLA_Personale(in_CdCdr in varchar2)
 return varchar2 is
  aLA   linea_attivita.cd_linea_attivita%type;
 begin
  select cd_linea_Attivita
  into   aLA
  from   linea_attivita
  where  cd_centro_responsabilita = in_CdCdr and
         cd_tipo_linea_attivita = 'SAUOP';
  return aLA;
 end;
/