eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAYWSDYG_PKG dependencies on ALL_TAB_COLUMNS

Line 1481: FROM all_tab_columns atc

1477: --
1478: -- Cursor to fetch the nullable flag
1479: CURSOR get_null(cp_table IN VARCHAR2) IS
1480: SELECT atc.nullable
1481: FROM all_tab_columns atc
1482: WHERE atc.column_name = 'BUSINESS_GROUP_ID'
1483: AND atc.table_name = p_table
1484: AND atc.owner = g_pay_schema;
1485: --

Line 1515: FROM all_tab_columns atc

1511: --
1512: -- Cursor to fetch the nullable flag
1513: CURSOR get_null(cp_table IN VARCHAR2) IS
1514: SELECT atc.nullable
1515: FROM all_tab_columns atc
1516: WHERE atc.column_name = 'PAYROLL_ID'
1517: AND atc.table_name = p_table
1518: AND atc.owner = g_pay_schema;
1519: --

Line 2632: from all_tab_columns

2628:
2629: cursor csr_col_type (cp_tab_name varchar2, cp_col_name varchar2)
2630: is
2631: select data_type
2632: from all_tab_columns
2633: where table_name = cp_tab_name
2634: and column_name like cp_col_name
2635: and owner = g_pay_schema
2636: and rownum = 1; --Assuming if the params been truc'd to 30 then its the only col