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 225: SELECT 1 INTO dummy FROM dual WHERE NOT EXISTS

221: X_Effectivity_Date DATE,
222: X_bill_or_eco NUMBER) IS
223: dummy NUMBER;
224: BEGIN
225: SELECT 1 INTO dummy FROM dual WHERE NOT EXISTS
226: (SELECT 1 from bom_inventory_components
227: WHERE bill_sequence_id = X_Bill_Sequence_Id
228: AND component_item_id = X_Component_Item_Id
229: AND operation_seq_num = X_Operation_Seq_Num

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

250: X_From_Unit_Number VARCHAR2,
251: X_bill_or_eco NUMBER) IS
252: dummy NUMBER;
253: BEGIN
254: SELECT 1 INTO dummy FROM dual WHERE NOT EXISTS
255: (SELECT 1 from bom_inventory_components
256: WHERE bill_sequence_id = X_Bill_Sequence_Id
257: AND component_item_id = X_Component_Item_Id
258: AND operation_seq_num = X_Operation_Seq_Num

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

342: , X_basis_type NUMBER
343: ) IS
344: CURSOR C IS SELECT rowid FROM BOM_INVENTORY_COMPONENTS
345: WHERE component_sequence_id = X_Component_Sequence_Id;
346: CURSOR C2 IS SELECT bom_inventory_components_s.nextval FROM sys.dual;
347:
348: l_object_revision_id NUMBER;
349: l_minor_revision_id NUMBER;
350: l_comp_revision_id NUMBER;