APPS.AD_ZD_SEED dependencies on DBA_CONSTRAINTS

Line 323: from dba_constraints o

319: and c.column_name = 'ZD_EDITION_NAME' );
320:
321: cursor C_CONSTRAINT_CUR (x_tab_owner varchar2, x_tab_name varchar2) is
322: select constraint_name, constraint_type
323: from dba_constraints o
324: where owner = x_tab_owner
325: and table_name = x_tab_name
326: and constraint_type in ('U','P')
327: and not exists ( select null

Line 558: from dba_indexes i, dba_constraints c

554: , ic.column_name
555: , nvl(col.nullable, 'Y') nullable
556: from
557: ( select i.owner, i.index_name, c.constraint_name
558: from dba_indexes i, dba_constraints c
559: where i.table_owner = x_owner
560: and i.table_name = x_tab_name
561: and i.uniqueness = 'UNIQUE'
562: and i.index_type = 'NORMAL' /* exclude other index types */

Line 950: from dba_constraints o

946: and c.column_name = 'ZD_EDITION_NAME' );
947:
948: cursor C_CONSTRAINT_CUR (x_tab_owner varchar2, x_tab_name varchar2) is
949: select constraint_name, constraint_type
950: from dba_constraints o
951: where owner = x_tab_owner
952: and table_name = x_tab_name
953: and constraint_type in ('U','P')
954: and exists ( select null