APPS.BOM_ALTERNATE_DESIGNATORS_PKG dependencies on DUAL

Line 127: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS

123: PROCEDURE Check_Unique(X_Organization_Id NUMBER,
124: X_Alternate_Designator_Code VARCHAR2) IS
125: DUMMY NUMBER;
126: BEGIN
127: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
128: (SELECT 1 FROM BOM_ALTERNATE_DESIGNATORS
129: WHERE Organization_Id = X_Organization_Id
130: AND Alternate_Designator_Code = X_Alternate_Designator_Code
131: );

Line 147: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS

143: X_Alternate_Designator_Code VARCHAR2) IS
144: DUMMY NUMBER;
145: MESSAGE_NAME VARCHAR2(80);
146: BEGIN
147: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
148: (SELECT 1 FROM BOM_BILL_OF_MATERIALS
149: WHERE BOM_BILL_OF_MATERIALS.Organization_ID = X_Organization_Id
150: AND BOM_BILL_OF_MATERIALS.Alternate_Bom_Designator =
151: X_Alternate_Designator_Code

Line 154: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS

150: AND BOM_BILL_OF_MATERIALS.Alternate_Bom_Designator =
151: X_Alternate_Designator_Code
152: );
153:
154: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
155: (SELECT 1 FROM BOM_OPERATIONAL_ROUTINGS
156: WHERE BOM_OPERATIONAL_ROUTINGS.Organization_Id = X_Organization_Id
157: AND BOM_OPERATIONAL_ROUTINGS.ALTERNATE_ROUTING_DESIGNATOR =
158: X_Alternate_Designator_Code

Line 161: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS

157: AND BOM_OPERATIONAL_ROUTINGS.ALTERNATE_ROUTING_DESIGNATOR =
158: X_Alternate_Designator_Code
159: );
160:
161: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
162: (SELECT 1 FROM CST_COST_TYPES
163: WHERE CST_COST_TYPES.Organization_Id = X_Organization_Id
164: AND CST_COST_TYPES.ALTERNATE_BOM_DESIGNATOR =
165: X_Alternate_Designator_Code