APPS.EDW_SEC_UTIL dependencies on EDW_SEC_LVL_INFO_T

Line 34: delete from edw_sec_lvl_info_t;

30: -- First delete data from tables
31:
32: delete from edw_sec_dim_info_t;
33: delete from edw_sec_fact_info_t;
34: delete from edw_sec_lvl_info_t;
35: delete from edw_sec_itemset_info_t;
36:
37:
38: -- Now populate tables from owb repository views

Line 70: insert into edw_sec_lvl_info_t

66: dim_id,
67: fk_col_name
68: from edw_sec_fact_info_v;
69:
70: insert into edw_sec_lvl_info_t
71: (dim_id,
72: level_id,
73: level_name,
74: level_long_name,

Line 191: edw_sec_lvl_info_t lvl

187: where level_id <>
188: (select
189: lvl.level_id
190: from
191: edw_sec_lvl_info_t lvl
192: WHERE
193: edw.level_short_name = lvl.level_name
194: and edw.dim_id = lvl.dim_id
195: );