APPS.FII_AR_REVENUE_B_C dependencies on DBA_TABLES

Line 294: -- Bug 4942753: Changed to select from dba_tables instead of all_tables

290: THEN NULL;
291: END IF;
292:
293: g_section := 'Section 40';
294: -- Bug 4942753: Changed to select from dba_tables instead of all_tables
295: SELECT tablespace_name
296: INTO g_tablespace
297: FROM dba_tables
298: WHERE table_name = g_table_name

Line 297: FROM dba_tables

293: g_section := 'Section 40';
294: -- Bug 4942753: Changed to select from dba_tables instead of all_tables
295: SELECT tablespace_name
296: INTO g_tablespace
297: FROM dba_tables
298: WHERE table_name = g_table_name
299: AND owner = g_fii_schema;
300:
301: g_section := 'Section 50';

Line 2076: -- Bug 4942753: Changed to select from dba_tables instead of all_tables

2072: IF(FND_INSTALLATION.GET_APP_INFO('AR', k_status, k_industry, k_ar_schema))
2073: THEN NULL;
2074: END IF;
2075:
2076: -- Bug 4942753: Changed to select from dba_tables instead of all_tables
2077: -- and changed to return 1 if any row exists
2078: BEGIN
2079: select 1 into l_count from dba_tables
2080: where table_name = 'AR_DEFERRED_LINES_ALL'

Line 2079: select 1 into l_count from dba_tables

2075:
2076: -- Bug 4942753: Changed to select from dba_tables instead of all_tables
2077: -- and changed to return 1 if any row exists
2078: BEGIN
2079: select 1 into l_count from dba_tables
2080: where table_name = 'AR_DEFERRED_LINES_ALL'
2081: and owner = k_ar_schema
2082: and rownum = 1;
2083: EXCEPTION

Line 2095: -- Bug 4942753: Changed to select from dba_tables instead of all_tables

2091: select /*+ parallel(trail) */
2092: CUSTOMER_TRX_LINE_ID lid
2093: from AR_DEFERRED_LINES_ALL trail';
2094: else
2095: -- Bug 4942753: Changed to select from dba_tables instead of all_tables
2096: -- and changed to return 1 if any row exists
2097: BEGIN
2098: select 1 into l_count from dba_tables
2099: where table_name = 'AR_RAMC_AUDIT_TRAIL'

Line 2098: select 1 into l_count from dba_tables

2094: else
2095: -- Bug 4942753: Changed to select from dba_tables instead of all_tables
2096: -- and changed to return 1 if any row exists
2097: BEGIN
2098: select 1 into l_count from dba_tables
2099: where table_name = 'AR_RAMC_AUDIT_TRAIL'
2100: and owner = k_ar_schema
2101: and rownum = 1;
2102: EXCEPTION