APPS.BOMPCOAN dependencies on ENG_ENGINEERING_CHANGES

Line 93: FROM ENG_ENGINEERING_CHANGES

89:
90: SELECT GREATEST(P_NEXT_NUMBER,
91: NVL(MAX(TO_NUMBER(LTRIM(CHANGE_NOTICE,P_PREFIX_TEMP))),0)+1)
92: INTO P_GREATEST_NUM
93: FROM ENG_ENGINEERING_CHANGES
94: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
95: AND RTRIM(CHANGE_NOTICE,'0123456789') = P_PREFIX_TEMP;
96:
97: P_NEXT_NUMBER := GREATEST(P_GREATEST_NUM, P_NEXT_NUMBER);