APPS.PAY_CC_PROCESS_UTILS dependencies on DBA_TAB_COLUMNS

Line 705: -- Bug 15882261 : Modified cursor definition to refer dba_tab_columns

701: -- and data_type in ('NUMBER', 'VARCHAR2', 'DATE')
702: -- order by column_name;
703:
704:
705: -- Bug 15882261 : Modified cursor definition to refer dba_tab_columns
706: -- instead of all_tab_columns
707:
708: cursor get_columns (p_tab_name in varchar2)
709: is

Line 713: from dba_tab_columns tab, user_synonyms syn

709: is
710: select substr(tab.column_name, 1, 24) column_name,
711: tab.column_name full_column_name,
712: tab.data_type
713: from dba_tab_columns tab, user_synonyms syn
714: where syn.synonym_name = p_tab_name
715: and tab.table_name = syn.table_name
716: and tab.owner = syn.table_owner
717: and tab.owner = g_pay_schema

Line 1048: -- Bug 15882261 : Modified cursor definition to refer dba_tab_columns

1044: -- 1),
1045: -- column_name;
1046:
1047:
1048: -- Bug 15882261 : Modified cursor definition to refer dba_tab_columns
1049: -- instead of all_tab_columns
1050:
1051: cursor get_columns (p_tab_name in varchar2,
1052: p_start in varchar2,

Line 1059: from dba_tab_columns tab, user_synonyms syn

1055: is
1056: select substr(tab.column_name, 1, 24) column_name,
1057: tab.column_name full_column_name,
1058: tab.data_type
1059: from dba_tab_columns tab, user_synonyms syn
1060: where syn.synonym_name = p_tab_name
1061: and tab.table_name = syn.table_name
1062: and tab.owner = syn.table_owner
1063: and tab.owner = l_owner

Line 1520: -- Bug 15882261 : Modified cursor definition to refer dba_tab_columns

1516: -- 'OBJECT_VERSION_NUMBER')
1517: -- and data_type in ('NUMBER', 'VARCHAR2', 'DATE')
1518: -- order by column_name;
1519:
1520: -- Bug 15882261 : Modified cursor definition to refer dba_tab_columns
1521: -- instead of all_tab_columns
1522:
1523: cursor get_columns (p_tab_name in varchar2)
1524: is

Line 1528: from dba_tab_columns tab, user_synonyms syn

1524: is
1525: select substr(tab.column_name, 1, 24) column_name,
1526: tab.column_name full_column_name,
1527: tab.data_type
1528: from dba_tab_columns tab, user_synonyms syn
1529: where syn.synonym_name = p_tab_name
1530: and tab.table_name = syn.table_name
1531: and tab.owner = syn.table_owner
1532: and tab.owner = g_pay_schema