DBA Data[Home] [Help]

APPS.OKL_RULE_APIS_PVT dependencies on DBA_TAB_COLUMNS

Line 875: /* commenting the code below as the direct reference of dba_tab_columns is not allowed

871: Where job.object_code = p_object_code
872: And nvl(job.start_date_active,sysdate) <= sysdate
873: And nvl(job.end_date_active,sysdate+1) > sysdate;
874:
875: /* commenting the code below as the direct reference of dba_tab_columns is not allowed
876: --Cursor check_col_curs(p_table_name IN Varchar2,p_col_name IN Varchar2) is
877: --Select 'Y'
878: --From dba_tab_columns
879: --Where table_name = p_table_name

Line 878: --From dba_tab_columns

874:
875: /* commenting the code below as the direct reference of dba_tab_columns is not allowed
876: --Cursor check_col_curs(p_table_name IN Varchar2,p_col_name IN Varchar2) is
877: --Select 'Y'
878: --From dba_tab_columns
879: --Where table_name = p_table_name
880: --And column_name = p_col_name
881: -----------------
882: --Bug# 3431854 :

Line 889: from user_synonyms syn, dba_tab_columns col

885: */
886:
887: Cursor check_col_curs(p_table_name IN Varchar2,p_col_name IN Varchar2) is
888: select 'Y'
889: from user_synonyms syn, dba_tab_columns col
890: where syn.synonym_name = p_table_name
891: and col.owner = syn.table_owner
892: and col.table_name = syn.table_name
893: and col.column_name = p_col_name