APPS.AMS_LIST_PURGE_PVT dependencies on AMS_QUERY_TEMP_INST_COND_ASSOC

Line 988: FROM ams_query_temp_inst_cond_assoc assoc,

984:
985: FORALL i in 1 .. p_id_tbl.count
986: DELETE from ams_query_condition_value value
987: WHERE EXISTS (SELECT 1
988: FROM ams_query_temp_inst_cond_assoc assoc,
989: ams_query_template_instance inst
990: WHERE assoc.template_instance_id = inst.template_instance_id
991: AND value.assoc_id = assoc.assoc_id
992: AND inst.instance_used_by_id = p_id_tbl(i));

Line 995: DELETE from AMS_QUERY_TEMP_INST_COND_ASSOC assoc

991: AND value.assoc_id = assoc.assoc_id
992: AND inst.instance_used_by_id = p_id_tbl(i));
993:
994: FORALL i in 1 .. p_id_tbl.count
995: DELETE from AMS_QUERY_TEMP_INST_COND_ASSOC assoc
996: WHERE EXISTS (SELECT 1
997: FROM ams_query_template_instance inst
998: WHERE assoc.template_instance_id = inst.template_instance_id
999: AND inst.instance_used_by_id = p_id_tbl(i));