APPS.ENG_ECO_PRIOR_PKG dependencies on DUAL

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

6: X_Org_id NUMBER,
7: X_Priority_code VARCHAR2) IS
8: dummy number;
9: BEGIN
10: select 1 into dummy from dual where not exists
11: (select 1 from eng_change_priorities
12: where ENG_CHANGE_PRIORITY_CODE = X_Priority_code
13: and ORGANIZATION_ID = X_Org_id
14: );

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

23: X_Org_id NUMBER,
24: X_Priority_code VARCHAR2) IS
25: DUMMY NUMBER;
26: BEGIN
27: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
28: (SELECT 1 FROM ENG_ENGINEERING_CHANGES
29: WHERE ORGANIZATION_ID = X_Org_id
30: AND PRIORITY_CODE = X_Priority_code
31: );