APPS.EDW_MAPPING_COLLECT dependencies on EDW_LEVELS_MD_V

Line 14563: select dim_id,LEVEL_PREFIX from edw_levels_md_v where LEVEL_TABLE_NAME=p_ltc;

14559: --
14560: cursor c1(p_ltc varchar2,p_table_owner varchar2) is
14561: select LOG_TABLE from all_snapshot_logs where master=p_ltc and LOG_OWNER=p_table_owner;
14562: cursor c2(p_ltc varchar2) is
14563: select dim_id,LEVEL_PREFIX from edw_levels_md_v where LEVEL_TABLE_NAME=p_ltc;
14564: --
14565: l_snplog varchar2(100);
14566: l_table varchar2(100);
14567: l_ll_snplog_has_pk boolean:=false;

Line 14580: write_to_log_file_n('select dim_id,LEVEL_PREFIX from edw_levels_md_v where LEVEL_TABLE_NAME='||p_ltc);

14576: if g_debug then
14577: write_to_log_file_n('In merge_pci_snplog'||get_time);
14578: end if;
14579: if g_debug then
14580: write_to_log_file_n('select dim_id,LEVEL_PREFIX from edw_levels_md_v where LEVEL_TABLE_NAME='||p_ltc);
14581: end if;
14582: open c2(p_ltc);
14583: fetch c2 into l_dim_id,l_prefix;
14584: close c2;