APPS.BOM_BILL_OF_MATLS_PKG dependencies on DUAL

Line 118: SELECT 1 INTO dummy FROM dual

114: X_Alternate_Bom_Designator VARCHAR2,
115: X_Organization_Id NUMBER) IS
116: dummy NUMBER;
117: BEGIN
118: SELECT 1 INTO dummy FROM dual
119: WHERE not exists
120: (SELECT 1 FROM bom_bill_of_materials
121: WHERE assembly_item_id = X_Assembly_item_id
122: AND nvl(alternate_bom_designator,'no alt') =

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

172: l_preferred_flag Varchar2(1);
173: x_err_text varchar2(2000);
174: CURSOR C IS SELECT rowid FROM BOM_BILL_OF_MATERIALS
175: WHERE bill_sequence_id = X_Bill_Sequence_Id;
176: CURSOR C2 IS SELECT bom_inventory_components_s.nextval FROM sys.dual;
177: BEGIN
178: if (X_Bill_Sequence_Id is NULL) then
179: OPEN C2;
180: FETCH C2 INTO X_Bill_Sequence_Id;