APPS.EDW_MAPPING_COLLECT dependencies on ALL_SNAPSHOT_LOGS

Line 14561: select LOG_TABLE from all_snapshot_logs where master=p_ltc and LOG_OWNER=p_table_owner;

14557: p_ul_table varchar2
14558: )return boolean is
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);

Line 14593: write_to_log_file_n('select LOG_TABLE from all_snapshot_logs where master='||p_ltc||

14589: if edw_owb_collection_util.drop_table(l_snplogs_L)=false then
14590: null;
14591: end if;
14592: if g_debug then
14593: write_to_log_file_n('select LOG_TABLE from all_snapshot_logs where master='||p_ltc||
14594: ' and LOG_OWNER='||p_table_owner);
14595: end if;
14596: open c1(p_ltc,p_table_owner);
14597: fetch c1 into l_snplog;