DBA Data[Home] [Help]

APPS.IEC_RECORD_FILTER_PVT dependencies on ALL_VIEWS

Line 395: FROM ALL_VIEWS

391:
392: BEGIN
393: SELECT 1
394: INTO l_ignore
395: FROM ALL_VIEWS
396: WHERE VIEW_NAME = UPPER(l_view_name)
397: AND OWNER = UPPER(l_view_owner);
398:
399: EXECUTE IMMEDIATE 'DROP VIEW ' || l_view_name;

Line 552: FROM ALL_VIEWS

548: l_view_owner := Get_AppsSchemaName;
549: BEGIN
550: EXECUTE IMMEDIATE
551: 'SELECT VIEW_NAME
552: FROM ALL_VIEWS
553: WHERE VIEW_NAME = UPPER(:source_type_view)
554: AND OWNER = UPPER(:owner)'
555: INTO l_ignore
556: USING x_source_type_view