Append APPS with every object
We have serveral customized packages, procedures and functions in APPS schema in which many seeded tables are being used. We are moving all these packages, procedures and functions to custom schema. After moving to custom schema these packages, procedures and functions will not compiled. I want to find a flexible and practical way to append APPS with every seeded table or view in our customized packages, procedures and functions.