APPS.BIM_I_SGMT_ACT_FACTS_PKG dependencies on AMS_LIST_QUERIES_ALL

Line 281: from ams_list_queries_all ;

277: l_query_string VARCHAR2(32767);
278:
279: cursor c_query_source is
280: select list_query_id, query
281: from ams_list_queries_all ;
282:
283: l_found VARCHAR2(1) := 'N';
284: l_master_type VARCHAR2(80);
285: l_master_type_id NUMBER;

Line 430: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_safb d ' ||

426: ' ,d.source_code_id ' ||
427: ' FROM ams_act_lists a ' ||
428: ' , ams_campaign_schedules_b b ' ||
429: ' , (SELECT a.cell_id ' ||
430: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_safb d ' ||
431: ' WHERE b.act_list_query_used_by_id = a.cell_id ' ||
432: ' AND b.arc_act_list_query_used_by =''CELL'' ' ||
433: ' AND b.list_query_id = d.sql_id ' ||
434: ' AND d.source_name = c.source_type_code ' ||

Line 562: from ams_list_queries_all ;

558: l_query_string VARCHAR2(32767);
559:
560: cursor c_query_source is
561: select list_query_id, query
562: from ams_list_queries_all ;
563:
564: l_found VARCHAR2(1) := 'N';
565: l_master_type VARCHAR2(80);
566: l_master_type_id NUMBER;

Line 702: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_safb d ' ||

698: ' ,d.source_code_id ' ||
699: ' FROM ams_act_lists a ' ||
700: ' , ams_campaign_schedules_b b ' ||
701: ' , (SELECT a.cell_id ' ||
702: ' FROM ams_cells_all_b a, ams_list_queries_all b, ams_list_src_types c, source_query_safb d ' ||
703: ' WHERE b.act_list_query_used_by_id = a.cell_id ' ||
704: ' AND b.arc_act_list_query_used_by = ''CELL'' ' ||
705: ' AND b.list_query_id = d.sql_id ' ||
706: ' AND d.source_name = c.source_type_code ' ||