APPS.ENG_ECO_PRIOR_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 10

    select 1 into dummy from dual where not exists
	(select 1 from eng_change_priorities
	where ENG_CHANGE_PRIORITY_CODE = X_Priority_code
	and   ORGANIZATION_ID = X_Org_id
	);

Line: 27

       SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
         (SELECT 1 FROM ENG_ENGINEERING_CHANGES
          WHERE ORGANIZATION_ID = X_Org_id
            AND PRIORITY_CODE = X_Priority_code
         );

Line: 35

         FND_MESSAGE.SET_NAME('ENG', 'ENG_CANNOT_DELETE_USED');