APPS.BOM_TA_EXCLUSIONS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

PROCEDURE Delete_Item_TA_Exclusions (p_del_comp_seq NUMBER,
                                     x_return_status OUT NOCOPY VARCHAR2) IS
l_bill_seq_id   NUMBER;

Line: 10

  SELECT bill_sequence_id,component_item_id
    FROM bom_inventory_components
   WHERE component_sequence_id = p_del_comp_seq;

Line: 23

 DELETE FROM BOM_TA_VAL_EXCLUSION_DEF_B
      WHERE EXCLUSION_RULE_ID IN
      (SELECT EXCLUSION_RULE_ID FROM BOM_TA_VAL_EXCLUSION_RULES_B
       WHERE COMPONENT_ITEM_ID = l_comp_item_id
       AND PARENT_BILL_SEQ_ID = l_bill_seq_id
       AND 1 = (SELECT COUNT(*)
               FROM BOM_INVENTORY_COMPONENTS
	       WHERE  COMPONENT_ITEM_ID = l_comp_item_id
	       AND BILL_SEQUENCE_ID = l_bill_seq_id)
      );

Line: 35

DELETE FROM BOM_TA_VAL_EXCLUSION_RULES_B
      WHERE EXCLUSION_RULE_ID IN
      (SELECT EXCLUSION_RULE_ID FROM BOM_TA_VAL_EXCLUSION_RULES_B
       WHERE COMPONENT_ITEM_ID = l_comp_item_id
       AND PARENT_BILL_SEQ_ID = l_bill_seq_id
       AND 1 = (SELECT COUNT(*)
               FROM BOM_INVENTORY_COMPONENTS
	       WHERE  COMPONENT_ITEM_ID = l_comp_item_id
	       AND BILL_SEQUENCE_ID = l_bill_seq_id)
      );

Line: 51

END Delete_Item_TA_Exclusions;