DBA Data[Home] [Help]

APPS.CS_STD dependencies on CS_SYSTEMS

Line 470: l_system_name cs_systems.name%type;

466: (
467: p_system_id number,
468: p_error_flag varchar2 default 'TRUE'
469: ) return varchar2 is
470: l_system_name cs_systems.name%type;
471: begin
472: if p_system_id is null then
473: raise NO_DATA_FOUND;
474: end if;

Line 478: from cs_systems

474: end if;
475: --
476: select name
477: into l_system_name
478: from cs_systems
479: where system_id = p_system_id;
480: --
481: return(l_system_name);
482: --