DBA Data[Home] [Help]

APPS.B_STD_OP_RES_PKG dependencies on DUAL

Line 560: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS

556: X_Standard_Operation_Id NUMBER,
557: X_Resource_Seq_Num NUMBER) IS
558: dummy NUMBER;
559: BEGIN
560: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
561: (SELECT 1 FROM BOM_STD_OP_RESOURCES
562: WHERE Standard_Operation_Id = X_Standard_Operation_Id
563: AND Resource_Seq_Num = X_Resource_Seq_Num
564: AND ((X_Rowid IS NULL) OR (ROWID <> X_Rowid))