APPS.HXC_APPROVAL_WF_PKG dependencies on USER_PROCEDURES

Line 4926: l_proc_name user_procedures.procedure_name%TYPE;

4922: FUNCTION code_chk (p_code IN VARCHAR2) RETURN BOOLEAN IS
4923: --
4924: l_package_name user_source.name%TYPE;
4925: -- Bug 15963472
4926: l_proc_name user_procedures.procedure_name%TYPE;
4927: l_dummy VARCHAR2(1);
4928: l_code BOOLEAN := FALSE;
4929: --
4930: BEGIN

Line 4969: FROM user_procedures

4965: */
4966:
4967: SELECT 'Y'
4968: INTO l_dummy
4969: FROM user_procedures
4970: WHERE object_name = l_package_name
4971: AND object_type = 'PACKAGE'
4972: AND procedure_name = l_proc_name;
4973: