180: WHERE score.score_model_id = p_score_model_id
181: AND score.data_point_id = p_data_point_id
182: AND score.score_model_id = weight.score_model_id
183: AND score.data_point_id = weight.data_point_id
184: AND fnd_number.canonical_to_number(l_data_point_value) between
185: fnd_number.canonical_to_number(score.range_from) and fnd_number.canonical_to_number(score.range_to);
186:
187: IF pg_debug = 'Y'
188: THEN
181: AND score.data_point_id = p_data_point_id
182: AND score.score_model_id = weight.score_model_id
183: AND score.data_point_id = weight.data_point_id
184: AND fnd_number.canonical_to_number(l_data_point_value) between
185: fnd_number.canonical_to_number(score.range_from) and fnd_number.canonical_to_number(score.range_to);
186:
187: IF pg_debug = 'Y'
188: THEN
189: debug ( 'l_scores : ' || l_scores );