APPS.BIM_PERIODIC_FACTS dependencies on ALL_TABLES

Line 44: FROM all_tables

40: PROCEDURE truncate_facts (p_object VARCHAR2 , p_confirm VARCHAR2 ) IS
41:
42: CURSOR trunc_camp_tables(p_owner varchar2) IS
43: SELECT 'TRUNCATE TABLE '|| owner ||'.' || table_name sqlstmt
44: FROM all_tables
45: WHERE table_name like 'BIM_R_CAMP_%LY%_FACTS'
46: AND owner = p_owner
47: AND table_name not like '%_MV%';
48:

Line 51: FROM all_tables

47: AND table_name not like '%_MV%';
48:
49: CURSOR trunc_even_tables(p_owner varchar2) IS
50: SELECT 'TRUNCATE TABLE '|| owner ||'.' || table_name sqlstmt
51: FROM all_tables
52: WHERE table_name like 'BIM_R_EVEN_%LY%_FACTS'
53: AND owner = p_owner
54: AND table_name not like '%_MV%';
55:

Line 58: FROM all_tables

54: AND table_name not like '%_MV%';
55:
56: CURSOR trunc_fund_tables(p_owner varchar2) IS
57: SELECT 'TRUNCATE TABLE '|| owner ||'.' || table_name sqlstmt
58: FROM all_tables
59: WHERE (table_name like 'BIM_R_FUND_%LY%_FACTS' or table_name like 'BIM_R_FDSP_%LY%_FACTS')
60: AND owner = p_owner
61: AND table_name not like '%_MV%';
62:

Line 65: FROM all_tables

61: AND table_name not like '%_MV%';
62:
63: CURSOR trunc_lead_tables(p_owner varchar2) IS
64: SELECT 'TRUNCATE TABLE ' || owner ||'.'||table_name sqlstmt
65: FROM all_tables
66: WHERE table_name like 'BIM_R_LEAD_%_FACTS'
67: AND owner = p_owner
68: AND table_name not like '%_MV%';
69:

Line 72: FROM all_tables

68: AND table_name not like '%_MV%';
69:
70: CURSOR trunc_limp_tables(p_owner varchar2) IS
71: SELECT 'TRUNCATE TABLE ' || owner ||'.'||table_name sqlstmt
72: FROM all_tables
73: WHERE table_name like 'BIM_R_LIMP_%LY%_FACTS'
74: AND owner = p_owner
75: AND table_name not like '%_MV%';
76:

Line 79: FROM all_tables

75: AND table_name not like '%_MV%';
76:
77: CURSOR trunc_resp_tables(p_owner varchar2) IS
78: SELECT 'TRUNCATE TABLE ' || owner ||'.'||table_name sqlstmt
79: FROM all_tables
80: WHERE (table_name like 'BIM_R_RRSN_%LY%_FACTS' OR table_name like 'BIM_R_RGRD_%LY%_FACTS')
81: AND owner = p_owner
82: AND table_name not like '%_MV%';
83: