DBA Data[Home] [Help]

APPS.CS_STD dependencies on CS_SYSTEMS

Line 471: l_system_name cs_systems.name%type;

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

Line 479: from cs_systems

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