DBA Data[Home] [Help]

APPS.IEC_WHERECLAUSE_PVT dependencies on IEC_LOOKUPS

Line 176: select b.tag into l_viewname from ams_list_headers_all a, iec_lookups b where

172:
173: PROCEDURE getAMSView( listHeaderId number, viewName out varchar2) AS
174: l_viewname VARCHAR2(100) := NULL;
175: BEGIN
176: select b.tag into l_viewname from ams_list_headers_all a, iec_lookups b where
177: a.list_header_id = listHeaderId and b.lookup_type='IEC_SOURCE_VIEW_MAP' and a.list_source_type = b.lookup_code;
178: viewname := l_viewname;
179: EXCEPTION
180: WHEN others THEN