APPS.BOM_TA_EXCLUSIONS_PVT dependencies on BOM_TA_VAL_EXCLUSION_RULES_B

Line 25: (SELECT EXCLUSION_RULE_ID FROM BOM_TA_VAL_EXCLUSION_RULES_B

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
28: AND 1 = (SELECT COUNT(*)
29: FROM BOM_INVENTORY_COMPONENTS

Line 35: DELETE FROM BOM_TA_VAL_EXCLUSION_RULES_B

31: AND BILL_SEQUENCE_ID = l_bill_seq_id)
32: );
33:
34:
35: DELETE FROM BOM_TA_VAL_EXCLUSION_RULES_B
36: WHERE EXCLUSION_RULE_ID IN
37: (SELECT EXCLUSION_RULE_ID FROM BOM_TA_VAL_EXCLUSION_RULES_B
38: WHERE COMPONENT_ITEM_ID = l_comp_item_id
39: AND PARENT_BILL_SEQ_ID = l_bill_seq_id

Line 37: (SELECT EXCLUSION_RULE_ID FROM BOM_TA_VAL_EXCLUSION_RULES_B

33:
34:
35: DELETE FROM BOM_TA_VAL_EXCLUSION_RULES_B
36: WHERE EXCLUSION_RULE_ID IN
37: (SELECT EXCLUSION_RULE_ID FROM BOM_TA_VAL_EXCLUSION_RULES_B
38: WHERE COMPONENT_ITEM_ID = l_comp_item_id
39: AND PARENT_BILL_SEQ_ID = l_bill_seq_id
40: AND 1 = (SELECT COUNT(*)
41: FROM BOM_INVENTORY_COMPONENTS