APPS.BOM_INV_COMPS1_PKG dependencies on DUAL

Line 12: SELECT 1 INTO dummy FROM sys.dual

8: X_Disable_Date DATE,
9: X_Effectivity_Date DATE) IS
10: dummy NUMBER;
11: BEGIN
12: SELECT 1 INTO dummy FROM sys.dual
13: WHERE NOT EXISTS
14: (SELECT 1 FROM bom_inventory_components
15: WHERE bill_sequence_id = X_Bill_Sequence_Id
16: AND component_item_id = X_Component_Item_Id

Line 39: SELECT 1 INTO dummy FROM sys.dual

35: X_From_Unit_Number VARCHAR2,
36: X_To_Unit_Number VARCHAR2) IS
37: dummy NUMBER;
38: BEGIN
39: SELECT 1 INTO dummy FROM sys.dual
40: WHERE NOT EXISTS
41: (SELECT 1 FROM bom_inventory_components
42: WHERE bill_sequence_id = X_Bill_Sequence_Id
43: AND component_item_id = X_Component_Item_Id

Line 217: SELECT 1 INTO dummy FROM dual WHERE NOT EXISTS

213: X_Effectivity_Date DATE,
214: X_bill_or_eco NUMBER) IS
215: dummy NUMBER;
216: BEGIN
217: SELECT 1 INTO dummy FROM dual WHERE NOT EXISTS
218: (SELECT 1 from bom_inventory_components
219: WHERE bill_sequence_id = X_Bill_Sequence_Id
220: AND component_item_id = X_Component_Item_Id
221: AND operation_seq_num = X_Operation_Seq_Num

Line 246: SELECT 1 INTO dummy FROM dual WHERE NOT EXISTS

242: X_From_Unit_Number VARCHAR2,
243: X_bill_or_eco NUMBER) IS
244: dummy NUMBER;
245: BEGIN
246: SELECT 1 INTO dummy FROM dual WHERE NOT EXISTS
247: (SELECT 1 from bom_inventory_components
248: WHERE bill_sequence_id = X_Bill_Sequence_Id
249: AND component_item_id = X_Component_Item_Id
250: AND operation_seq_num = X_Operation_Seq_Num

Line 338: CURSOR C2 IS SELECT bom_inventory_components_s.nextval FROM sys.dual;

334: , X_basis_type NUMBER
335: ) IS
336: CURSOR C IS SELECT rowid FROM BOM_INVENTORY_COMPONENTS
337: WHERE component_sequence_id = X_Component_Sequence_Id;
338: CURSOR C2 IS SELECT bom_inventory_components_s.nextval FROM sys.dual;
339:
340: l_object_revision_id NUMBER;
341: l_minor_revision_id NUMBER;
342: l_comp_revision_id NUMBER;