DBA Data[Home] [Help]

APPS.PER_PAR_BUS dependencies on DBA_TAB_COLUMNS

Line 505: from user_synonyms syn, dba_tab_columns col

501: and column_name = upper(p_participation_in_column)
502: and owner = l_per_owner
503: */
504: select 'Y'
505: from user_synonyms syn, dba_tab_columns col
506: where syn.synonym_name = upper(p_participation_in_table)
507: and col.owner = syn.table_owner
508: and col.table_name = syn.table_name
509: and col.column_name = upper(p_participation_in_column);