APPS.CN_PROC_BATCHES_PKG dependencies on USER_OBJECTS

Line 3804: CURSOR l_chk_rule_package_csr(l_pkg_name user_objects.object_name%TYPE) IS

3800: AND start_date <= p_end_date
3801: AND p_start_date <= NVL(end_date, p_end_date)
3802: AND module_type = 'REVCLS';
3803:
3804: CURSOR l_chk_rule_package_csr(l_pkg_name user_objects.object_name%TYPE) IS
3805: SELECT COUNT(*)
3806: FROM user_objects ob
3807: WHERE ob.object_name = l_pkg_name AND ob.object_type = 'PACKAGE BODY';
3808:

Line 3806: FROM user_objects ob

3802: AND module_type = 'REVCLS';
3803:
3804: CURSOR l_chk_rule_package_csr(l_pkg_name user_objects.object_name%TYPE) IS
3805: SELECT COUNT(*)
3806: FROM user_objects ob
3807: WHERE ob.object_name = l_pkg_name AND ob.object_type = 'PACKAGE BODY';
3808:
3809: cached_org_id INTEGER;
3810: cached_org_append VARCHAR2(100);

Line 3811: l_cls_pkg_name user_objects.object_name%TYPE;

3807: WHERE ob.object_name = l_pkg_name AND ob.object_type = 'PACKAGE BODY';
3808:
3809: cached_org_id INTEGER;
3810: cached_org_append VARCHAR2(100);
3811: l_cls_pkg_name user_objects.object_name%TYPE;
3812: l_error_ctr NUMBER := 0;
3813: l_counter NUMBER := 0;
3814: x_covered BOOLEAN := FALSE;
3815: BEGIN