APPS.IGS_PS_OFR_OPT_PKG dependencies on USER_OBJECTS

Line 428: SELECT '1' FROM USER_OBJECTS

424:
425: PROCEDURE Check_Child_Existance AS
426:
427: CURSOR c_hesa IS
428: SELECT '1' FROM USER_OBJECTS
429: WHERE OBJECT_NAME = 'IGS_HE_POOUS_ALL_PKG'
430: AND object_type = 'PACKAGE BODY';
431: l_hesa VARCHAR2(1);
432: