4047: AND upper(short_code) = upper(p_short_code);
4048:
4049: BEGIN
4050:
4051: IF qa_plan_element_api.values_exist(p_plan_id, p_char_id) THEN
4052:
4053: OPEN c;
4054: FETCH c INTO l_return_value;
4055: CLOSE c;
4053: OPEN c;
4054: FETCH c INTO l_return_value;
4055: CLOSE c;
4056:
4057: ELSIF qa_plan_element_api.sql_validation_exists(p_char_id) THEN
4058:
4059: sql_string := qa_plan_element_api.get_sql_validation_string(p_char_id);
4060:
4061: --
4055: CLOSE c;
4056:
4057: ELSIF qa_plan_element_api.sql_validation_exists(p_char_id) THEN
4058:
4059: sql_string := qa_plan_element_api.get_sql_validation_string(p_char_id);
4060:
4061: --
4062: -- Bug 1474995. Adding filter to the user-defined SQL.
4063: --