APPS.GR_EURO_CLASSIFICATION dependencies on GR_WORK_SAFETY_PHRASES

Line 126: FROM gr_work_safety_phrases wsc

122: SELECT safety_phrase_code,
123: safety_rule_group,
124: safety_category_code,
125: category_value
126: FROM gr_work_safety_phrases wsc
127: WHERE wsc.session_id = g_session_id
128: AND wsc.item_code = g_current_item
129: AND wsc.assign_flag = 'Y'
130: ORDER BY wsc.safety_phrase_code,

Line 152: FROM gr_work_safety_phrases

148: CURSOR g_exists_work_phrase (V_item_code VARCHAR2, V_safety_phrase VARCHAR2) IS
149: SELECT 1
150: FROM dual
151: WHERE EXISTS (SELECT safety_phrase_code
152: FROM gr_work_safety_phrases
153: WHERE item_code = V_item_code
154: AND session_id = g_session_id
155: AND safety_phrase_code = V_safety_phrase
156: AND assign_flag = 'Y');