APPS.GR_ITEM_PROPERTIES_PUB dependencies on GR_RISK_PHRASES_VL

Line 144: FROM gr_risk_phrases_vl

140: WHERE safety_phrase_code = l_phrase_code;
141:
142: CURSOR c_get_risk_phrase_code IS
143: SELECT risk_phrase_code
144: FROM gr_risk_phrases_vl
145: WHERE risk_phrase_code = l_phrase_code;
146: riskcode c_get_risk_phrase_code%ROWTYPE;
147:
148: CURSOR c_get_item_safety_phrase IS

Line 481: -- Validate the value for phrase code against the GR_RISK_PHRASES_VL.

477: FALSE);
478: RAISE loop_exception;
479: END IF; -- IF l_phrase_code is null then
480:
481: -- Validate the value for phrase code against the GR_RISK_PHRASES_VL.
482: -- An error message will be written to the log file if the value is invalid
483: OPEN c_get_risk_phrase_code;
484: FETCH c_get_risk_phrase_code INTO riskcode;
485: IF c_get_risk_phrase_code%NOTFOUND THEN

Line 687: -- Validate the value for phrase code against the GR_RISK_PHRASES_VL.

683: l_last_update_login);
684:
685:
686: ELSIF l_form_block = 'RISK_PHRASES' THEN
687: -- Validate the value for phrase code against the GR_RISK_PHRASES_VL.
688: -- An error message will be written to the log file if the value is invalid
689: OPEN c_get_risk_phrase_code;
690: FETCH c_get_risk_phrase_code INTO riskcode;
691: IF c_get_risk_phrase_code%NOTFOUND THEN