APPS.ENG_ECN_APPROVAL_LISTS_PKG dependencies on DUAL

Line 34: CURSOR C2 IS SELECT eng_ecn_approval_lists_s.nextval FROM dual;

30: X_Last_Updated_By NUMBER
31: ) IS
32: CURSOR C IS SELECT rowid FROM eng_ecn_approval_lists
33: WHERE approval_list_id = X_Approval_List_Id;
34: CURSOR C2 IS SELECT eng_ecn_approval_lists_s.nextval FROM dual;
35:
36: myList wf_parameter_list_t;
37: l_username varchar2(320);
38: BEGIN

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

371:
372: PROCEDURE Check_References(X_Approval_List_Id NUMBER) IS
373: DUMMY NUMBER;
374: BEGIN
375: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
376: (SELECT 1 FROM ENG_ENGINEERING_CHANGES
377: WHERE Approval_List_Id = X_Approval_List_Id
378: );
379: EXCEPTION

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

385: PROCEDURE Check_Unique(X_Rowid VARCHAR2,
386: X_Approval_List_Name VARCHAR2) IS
387: DUMMY NUMBER;
388: BEGIN
389: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
390: (SELECT 1 FROM ENG_ECN_APPROVAL_LISTS
391: WHERE (Approval_List_Name = X_Approval_List_Name)
392: AND ((X_Rowid is NULL) or (ROWID <> X_Rowid))
393: );