APPS.ITG_SYNCITEMINBOUND_PVT dependencies on PO_HAZARD_CLASSES

Line 40: l_hazard_class_id po_hazard_classes.hazard_class_id%TYPE;

36: l_api_name CONSTANT VARCHAR2(30) := 'Sync_Item';
37: l_api_version CONSTANT NUMBER := 1.0;
38:
39: l_itemarray FND_FLEX_EXT.SegmentArray;
40: l_hazard_class_id po_hazard_classes.hazard_class_id%TYPE;
41: l_nested_exception EXCEPTION;
42:
43:
44: l_create_date DATE;

Line 168: FROM po_hazard_classes

164:
165: BEGIN
166: SELECT hazard_class_id
167: INTO l_hazard_class_id
168: FROM po_hazard_classes
169: WHERE upper(hazard_class) = upper(p_hazrdmatl);
170: EXCEPTION
171: WHEN NO_DATA_FOUND THEN
172: IF (l_Debug_Level <= 1) THEN