APPS.AMS_ACT_LIST_PVT dependencies on AMS_LIST_QUERIES_ALL

Line 4629: FROM ams_list_queries_all WHERE list_query_id = p_query_id;

4625: ) is
4626:
4627: CURSOR c_queries(p_query_id IN number) IS
4628: SELECT LIST_QUERY_ID
4629: FROM ams_list_queries_all WHERE list_query_id = p_query_id;
4630:
4631: --sql_string column is obsolete bug 4604653
4632: CURSOR fetch_list_queries_all(p_query_id NUMBER) IS
4633: SELECT list_query_id,name,type,query,primary_key,source_object_name,act_list_query_used_by_id,arc_act_list_query_used_by,seed_flag,parameterized_flag,admin_flag,query_template_id,query_type

Line 4640: FROM ams_list_queries_all

4636:
4637: /*
4638: CURSOR fetch_long_query_val(p_query_id NUMBER) IS
4639: SELECT query
4640: FROM ams_list_queries_all
4641: WHERE list_query_id = p_query_id;
4642: */
4643:
4644: long_var LONG;

Line 4711: UPDATE ams_list_queries_all

4707: /*
4708: OPEN fetch_long_query_val(p_old_query_id);
4709: FETCH fetch_long_query_val INTO long_var;
4710: */
4711: UPDATE ams_list_queries_all
4712: SET --query = long_var,
4713: parameterized_flag = l_queries_rec.parameterized_flag,
4714: admin_flag = l_queries_rec.admin_flag,
4715: query_template_id = l_queries_rec.query_template_id,