APPS.BSC_IM_UTILS dependencies on BSC_DB_TABLES_RELS

Line 71: select table_name from bsc_db_tables_rels

67: p_fk varchar2)
68: return boolean is
69: --------------------------------------------
70: cursor cSTableNameForB is
71: select table_name from bsc_db_tables_rels
72: where table_name like 'BSC_S%'
73: connect by source_table_name = prior table_name
74: start with source_table_name = p_b_pt_table_name;
75: --------------------------------------------

Line 3313: bsc_db_Tables_rels rels

3309: --owner=g_apps_owner;
3310:
3311: cursor cHigherLevel(p_lower_level varchar2) is
3312: select distinct substr(rels.table_name, 1, instr(rels.table_name, '_', -1))||'MV' from
3313: bsc_db_Tables_rels rels
3314: where rels.source_table_name like p_lower_level
3315: and rels.table_name not like p_lower_level
3316: and rels.table_name like 'BSC_S%';
3317: