APPS.CN_PROC_BATCHES_PKG dependencies on USER_OBJECTS

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

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

Line 3805: FROM user_objects ob

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

Line 3810: l_cls_pkg_name user_objects.object_name%TYPE;

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