APPS.CZ_ORAAPPS_INTEGRATE dependencies on USER_OBJECTS

Line 1418: FOR i IN (SELECT object_name FROM user_objects WHERE object_name like p_filter AND

1414: PROCEDURE compile_Dependents(p_filter IN VARCHAR2 -- DEFAULT 'CZ_IMP%'
1415: ) IS
1416:
1417: BEGIN
1418: FOR i IN (SELECT object_name FROM user_objects WHERE object_name like p_filter AND
1419: object_type='PACKAGE BODY' AND status='INVALID')
1420: LOOP
1421: BEGIN
1422: EXECUTE IMMEDIATE 'ALTER PACKAGE '||i.object_name||' COMPILE BODY';