APPS.PAYWSDYG_PKG dependencies on DBA_TAB_COLUMNS

Line 1486: -- Bug 15882261 : Modified the cursor definition to refer to dba_tab_columns

1482: -- WHERE atc.column_name = 'BUSINESS_GROUP_ID'
1483: -- AND atc.table_name = p_table
1484: -- AND atc.owner = g_pay_schema;
1485:
1486: -- Bug 15882261 : Modified the cursor definition to refer to dba_tab_columns
1487: -- instead of all_tab_columns
1488:
1489: CURSOR get_null(cp_table IN VARCHAR2) IS
1490: SELECT tab.nullable

Line 1491: FROM dba_tab_columns tab, user_synonyms syn

1487: -- instead of all_tab_columns
1488:
1489: CURSOR get_null(cp_table IN VARCHAR2) IS
1490: SELECT tab.nullable
1491: FROM dba_tab_columns tab, user_synonyms syn
1492: WHERE tab.column_name = 'BUSINESS_GROUP_ID'
1493: AND tab.table_name = syn.table_name
1494: AND tab.owner = syn.table_owner
1495: AND syn.synonym_name = p_table

Line 1535: -- Bug 15882261 : Modified the cursor definition to refer to dba_tab_columns

1531: -- AND atc.table_name = p_table
1532: -- AND atc.owner = g_pay_schema;
1533:
1534:
1535: -- Bug 15882261 : Modified the cursor definition to refer to dba_tab_columns
1536: -- instead of all_tab_columns
1537:
1538: CURSOR get_null(cp_table IN VARCHAR2) IS
1539: SELECT tab.nullable

Line 1540: FROM dba_tab_columns tab, user_synonyms syn

1536: -- instead of all_tab_columns
1537:
1538: CURSOR get_null(cp_table IN VARCHAR2) IS
1539: SELECT tab.nullable
1540: FROM dba_tab_columns tab, user_synonyms syn
1541: WHERE tab.column_name = 'PAYROLL_ID'
1542: AND tab.table_name = syn.table_name
1543: AND tab.owner = syn.table_owner
1544: AND syn.synonym_name = p_table

Line 2661: -- Bug 15882261 : Modified the cursor definition to refer to dba_tab_columns

2657: order by parameter_name;
2658:
2659:
2660:
2661: -- Bug 15882261 : Modified the cursor definition to refer to dba_tab_columns
2662: -- instead of all_tab_columns
2663:
2664: cursor csr_col_type (cp_tab_name varchar2, cp_col_name varchar2)
2665: is

Line 2667: from dba_tab_columns tab, user_synonyms syn

2663:
2664: cursor csr_col_type (cp_tab_name varchar2, cp_col_name varchar2)
2665: is
2666: select tab.data_type
2667: from dba_tab_columns tab, user_synonyms syn
2668: where syn.synonym_name = cp_tab_name
2669: and tab.table_name = syn.table_name
2670: and tab.owner = syn.table_owner
2671: and tab.column_name like cp_col_name