APPS.HR_PERSON_NAME dependencies on USER_OBJECTS

Line 672: from user_objects

668: l_procedure_name VARCHAR2(50);
669: --
670: cursor csr_leg_pkg(cp_pkg VARCHAR2) IS
671: select '1'
672: from user_objects
673: where object_name = cp_pkg
674: and object_type = 'PACKAGE';
675: --
676: CURSOR lgsl_pkb(cp_pkg VARCHAR2) IS

Line 678: FROM user_objects

674: and object_type = 'PACKAGE';
675: --
676: CURSOR lgsl_pkb(cp_pkg VARCHAR2) IS
677: SELECT object_name
678: FROM user_objects
679: WHERE object_type='PACKAGE BODY'
680: AND object_name = cp_pkg
681: AND length(object_name)=13
682: ORDER BY object_name;