APPS.BOM_VALIDATE dependencies on ALL_OBJECTS

Line 273: FROM all_objects

269: l_exists VARCHAR2(1) := 'N';
270: schema_name VARCHAR2(5):='APPS';
271: CURSOR c_check_object(cp_object_type VARCHAR2, cp_object_name VARCHAR2)IS
272: SELECT 'Y'
273: FROM all_objects
274: WHERE object_type = cp_object_type
275: AND owner = schema_name
276: AND object_name = cp_object_name
277: AND status = 'VALID';