DBA Data[Home] [Help]

APPS.BOMPECOD dependencies on ENG_REVISED_COMPONENTS

Line 58: DELETE FROM ENG_REVISED_COMPONENTS C

54: FROM ENG_REVISED_ITEMS R
55: WHERE R.ORGANIZATION_ID = P_ORGANIZATION_ID
56: AND R.CHANGE_NOTICE = P_CHANGE_NOTICE);
57:
58: DELETE FROM ENG_REVISED_COMPONENTS C
59: WHERE EXISTS
60: (SELECT NULL
61: FROM ENG_REVISED_ITEMS R
62: WHERE R.ORGANIZATION_ID = P_ORGANIZATION_ID