APPS.AMS_LIST_PURGE_PVT dependencies on AMS_QUERY_TEMPLATE_ALL
Line 1005: UPDATE ams_query_template_all qt
1001: FORALL i in 1 .. p_id_tbl.count
1002: DELETE from ams_query_template_instance
1003: WHERE instance_used_by_id = p_id_tbl(i);
1004: 1005: UPDATE ams_query_template_all qt 1006: SET in_use_flag = 'N'
1007: WHERE NOT EXISTS (SELECT 1
1008: FROM ams_query_template_instance inst
1009: WHERE qt.template_id = inst.template_id