APPS.EDW_SEC_POLICY SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 40

  select distinct fact_name into fact_short_name
  from edw_sec_fact_info_t
  where fact_long_name = fact_table_name;

Line: 49

  select count(*) into x_count from user_views
  where view_name = UPPER(fact_short_name);

Line: 58

        select table_owner into x_object_owner
        from user_synonyms --bug#4905343
	where synonym_name = UPPER(fact_short_name);

Line: 66

  DBMS_RLS.ADD_POLICY(x_object_owner, fact_short_name, 'edw_sec_policy', 'apps', 'edw_sec_pkg.dim_sec', 'select', TRUE);

Line: 125

  select distinct fact_name into fact_short_name
  from edw_sec_fact_info_t
  where fact_long_name = fact_table_name;

Line: 134

  select count(*) into x_count from user_views
  where view_name = UPPER(fact_short_name);

Line: 143

        select table_owner into x_object_owner
        from user_synonyms --bug#4905343
        where synonym_name = UPPER(fact_short_name);

Line: 216

  select distinct fact_name into fact_short_name
  from edw_sec_fact_info_t
  where fact_long_name = fact_table_name;

Line: 225

  select count(*) into x_count from user_views
  where view_name = UPPER(fact_short_name);

Line: 235

	select table_owner into x_object_owner
	from user_synonyms --bug#4905343
	where synonym_name = UPPER(fact_short_name);

Line: 243

  DBMS_RLS.ADD_POLICY(x_object_owner, fact_short_name, 'edw_sec_default_policy', 'apps', 'edw_sec_pkg.default_sec', 'select', TRUE);

Line: 301

  select distinct fact_name into fact_short_name
  from edw_sec_fact_info_t
  where fact_long_name = fact_table_name;

Line: 311

  select count(*) into x_count from user_views
  where view_name = UPPER(fact_short_name);

Line: 321

        select table_owner into x_object_owner
        from user_synonyms  --bug#4905343
        where synonym_name = UPPER(fact_short_name);