DBA Data[Home] [Help]

APPS.GR_EURO_CLASSIFICATION dependencies on GR_RISK_PHRASES_B

Line 80: gr_risk_phrases_b rp,

76: SELECT ir.risk_phrase_code,
77: rc.calculation_name_id,
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

Line 93: gr_risk_phrases_b rp,

89: SELECT ws.risk_phrase_code,
90: rc.calculation_name_id,
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