APPS.GR_EURO_CLASSIFICATION dependencies on GR_ITEM_CONCENTRATIONS

Line 9: G_INGREDIENT_ITEM GR_ITEM_CONCENTRATIONS.ingredient_item_code%TYPE;

5:
6: G_PKG_NAME CONSTANT VARCHAR2(255) := 'GR_EURO_CLASSIFICATION';
7:
8: G_CURRENT_ITEM GR_ITEM_GENERAL.item_code%TYPE;
9: G_INGREDIENT_ITEM GR_ITEM_CONCENTRATIONS.ingredient_item_code%TYPE;
10: G_LABEL_CODE GR_LABELS_B.label_code%TYPE;
11: G_PROPERTY_ID GR_ITEM_PROPERTIES.property_id%TYPE;
12: G_CURRENT_DATE DATE := sysdate;
13: G_PRODUCT_CLASS GR_PRODUCT_CLASSES.product_class%TYPE;

Line 82: gr_item_concentrations ic

78: rc.linked_risks_flag
79: FROM gr_item_risk_phrases ir,
80: gr_risk_phrases_b rp,
81: gr_risk_calculations rc,
82: gr_item_concentrations ic
83: WHERE ir.item_code = ic.ingredient_item_code
84: AND ir.item_code = g_ingredient_item
85: AND ir.risk_phrase_code = rp.risk_phrase_code
86: AND SUBSTR(ir.risk_phrase_code, 1,3) = rc.risk_phrase_code;

Line 95: gr_item_concentrations ic,

91: rc.linked_risks_flag
92: FROM gr_item_risk_phrases ir,
93: gr_risk_phrases_b rp,
94: gr_risk_calculations rc,
95: gr_item_concentrations ic,
96: gr_work_string ws
97: WHERE ir.item_code = ic.ingredient_item_code
98: AND ir.item_code = g_ingredient_item
99: AND ws.session_id = g_session_id