APPS.GR_EURO_CLASSIFICATION dependencies on GR_ITEM_CLASSNS

Line 141: FROM gr_item_classns ihc,

137: CURSOR g_get_item_classn IS
138: SELECT ihc.hazard_classification_code,
139: ehb.calculation_hierarchy,
140: ehb.hazard_group_code
141: FROM gr_item_classns ihc,
142: gr_eurohazards_b ehb
143: WHERE ihc.item_code = g_ingredient_item
144: AND ihc.hazard_classification_code = ehb.hazard_classification_code;
145: GlobalClassnRecord g_get_item_classn%ROWTYPE;