APPS.BIS_CREATE_REQUESTSET dependencies on ALL_TABLES

Line 1677: FROM all_tables

1673:
1674: /**
1675: CURSOR c_tab_owner(p_apps_schema_name varchar2) IS
1676: (SELECT owner
1677: FROM all_tables
1678: WHERE owner = p_apps_schema_name
1679: AND Upper(table_name) = Upper(p_obj_name))
1680: UNION ALL
1681: (SELECT s.table_owner owner

Line 1682: FROM user_synonyms s, all_tables t

1678: WHERE owner = p_apps_schema_name
1679: AND Upper(table_name) = Upper(p_obj_name))
1680: UNION ALL
1681: (SELECT s.table_owner owner
1682: FROM user_synonyms s, all_tables t
1683: WHERE t.owner = s.table_owner
1684: AND t.table_name = s.table_name
1685: AND t.table_name = Upper(p_obj_name));**/
1686:

Line 1689: FROM user_synonyms s, all_tables t

1685: AND t.table_name = Upper(p_obj_name));**/
1686:
1687: cursor c_tab_owner1 is
1688: SELECT s.table_owner owner
1689: FROM user_synonyms s, all_tables t
1690: WHERE t.owner = s.table_owner
1691: AND t.table_name = s.table_name
1692: AND s.synonym_name = Upper(p_obj_name);
1693:

Line 1696: from all_tables

1692: AND s.synonym_name = Upper(p_obj_name);
1693:
1694: cursor c_tab_owner2(p_apps_schema_name varchar2) IS
1695: select owner
1696: from all_tables
1697: where owner= p_apps_schema_name
1698: and table_name = Upper(p_obj_name);
1699:
1700: CURSOR c_view_owner(p_apps_schema_name varchar2) IS