APPS.INV_ABC_ASSIGNMENTS_PVT dependencies on MTL_ABC_ASSIGNMENT_GROUPS

Line 35: l_org_id mtl_abc_assignment_groups.organization_id%TYPE;

31: l_debug NUMBER := Nvl(fnd_profile.Value('INV_DEBUG_TRACE'), 0);
32:
33: l_abc_class_id NUMBER;
34: l_abc_classid_old NUMBER;
35: l_org_id mtl_abc_assignment_groups.organization_id%TYPE;
36: l_item_id mtl_abc_assignments.inventory_item_id%TYPE;
37: l_assignment_group_id mtl_abc_assignments.assignment_group_id%TYPE;
38: l_last_updated_by mtl_abc_assignments.last_updated_by%TYPE;
39: l_last_update_date mtl_abc_assignments.last_update_date%TYPE;

Line 50: FROM mtl_abc_assignment_groups

46: CURSOR check_assignment_group (
47: p_assignment_group_id NUMBER) IS
48: SELECT assignment_group_id,
49: organization_id
50: FROM mtl_abc_assignment_groups
51: WHERE assignment_group_id = p_assignment_group_id;
52:
53: CURSOR check_item_exists (
54: p_item_id NUMBER,