APPS.INV_LOT_ATTR_PUB dependencies on MTL_GRADES

Line 9: -- mtl_grades table

5: -- Name : validate_grade_code
6: -- Desc :
7: -- Generic routine to validates a grade code , item
8: -- must be grade controlled and grade must exist in
9: -- mtl_grades table
10: -- This function assumes that validation for itemid and orgin
11: -- have already taken place
12: -- I/P params :
13: -- p_grade_code, p_org_id and p_inventory_item_id (Mandatory)

Line 32: FROM mtl_grades

28: l_grade_control_flag VARCHAR2(1);
29:
30: CURSOR c_get_grade_code IS
31: SELECT grade_code
32: FROM mtl_grades
33: WHERE Grade_code = p_grade_code;
34:
35: CURSOR c_get_grade_flag IS
36: SELECT grade_control_flag