APPS.BOMPCOAN dependencies on ENG_ENG_CHANGES_INTERFACE

Line 193: FROM ENG_ENG_CHANGES_INTERFACE

189:
190: SELECT GREATEST(P_NEXT_NUMBER,
191: NVL(MAX(TO_NUMBER(LTRIM(CHANGE_NOTICE,P_PREFIX_TEMP))),0)+1)
192: INTO P_GREATEST_NUM
193: FROM ENG_ENG_CHANGES_INTERFACE
194: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
195: AND RTRIM(CHANGE_NOTICE,'0123456789') = P_PREFIX_TEMP;
196:
197: P_NEXT_NUMBER := GREATEST(P_GREATEST_NUM, P_NEXT_NUMBER);