APPS.BOMPCOAN dependencies on ENG_ENG_CHANGES_INTERFACE

Line 84: FROM ENG_ENG_CHANGES_INTERFACE

80:
81: SELECT GREATEST(P_NEXT_NUMBER,
82: NVL(MAX(TO_NUMBER(LTRIM(CHANGE_NOTICE,P_PREFIX_TEMP))),0)+1)
83: INTO P_GREATEST_NUM
84: FROM ENG_ENG_CHANGES_INTERFACE
85: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
86: AND RTRIM(CHANGE_NOTICE,'0123456789') = P_PREFIX_TEMP;
87:
88: P_NEXT_NUMBER := GREATEST(P_GREATEST_NUM, P_NEXT_NUMBER);