DBA Data[Home] [Help]

APPS.JL_CO_FA_PURGE_PKG dependencies on ALL_TABLES

Line 535: FROM all_tables

531: ---------------------------------------------------------
532:
533: SELECT count(*)
534: INTO x_count
535: FROM all_tables
536: WHERE table_name = x_adj_table
537: AND owner = x_oracle_username;
538:
539: ---------------------------------------------------------

Line 1332: FROM all_tables

1328: ---------------------------------------------------------
1329:
1330: SELECT count(*)
1331: INTO x_count
1332: FROM all_tables
1333: WHERE table_name = x_appr_table
1334: AND owner = x_oracle_username;
1335:
1336: ---------------------------------------------------------

Line 1360: FROM all_tables

1356: ---------------------------------------------------------
1357:
1358: SELECT count(*)
1359: INTO x_count
1360: FROM all_tables
1361: WHERE table_name = x_asset_table
1362: AND owner = x_oracle_username;
1363:
1364: ---------------------------------------------------------

Line 1388: FROM all_tables

1384: -- purge_id --
1385: ---------------------------------------------------------
1386: SELECT count(*)
1387: INTO x_count
1388: FROM all_tables
1389: WHERE table_name = x_book_table
1390: AND owner = x_oracle_username;
1391:
1392: