DBA Data[Home] [Help]

APPS.BOM_TA_EXCLUSIONS_PVT dependencies on BOM_TA_VAL_EXCLUSION_DEF_B

Line 23: DELETE FROM BOM_TA_VAL_EXCLUSION_DEF_B

19: l_bill_seq_id := c_comp_level.bill_sequence_id;
20: l_comp_item_id := c_comp_level.component_item_id;
21: END LOOP;
22:
23: DELETE FROM BOM_TA_VAL_EXCLUSION_DEF_B
24: WHERE EXCLUSION_RULE_ID IN
25: (SELECT EXCLUSION_RULE_ID FROM BOM_TA_VAL_EXCLUSION_RULES_B
26: WHERE COMPONENT_ITEM_ID = l_comp_item_id
27: AND PARENT_BILL_SEQ_ID = l_bill_seq_id