DBA Data[Home] [Help]

APPS.ENG_ENGINEERING_CHANGES_PKG dependencies on DUAL

Line 10: select 1 into dummy from dual where not exists

6: X_Change_Notice VARCHAR2,
7: X_Organization_Id NUMBER ) IS
8: dummy NUMBER;
9: BEGIN
10: select 1 into dummy from dual where not exists
11: (select 1 from ENG_ENGINEERING_CHANGES
12: where CHANGE_NOTICE = X_Change_Notice
13: and ORGANIZATION_ID = X_Organization_Id
14: and ((X_Rowid IS NULL) OR (ROWID <> X_Rowid))