APPS.AR_CMGT_SCORING_ENGINE dependencies on AR_CMGT_SCORE_WEIGHTS

Line 22: l_weight ar_cmgt_score_weights.weight%TYPE;

18: p_resultout OUT NOCOPY VARCHAR2 ) IS
19:
20: l_max_score ar_cmgt_score_dtls.scores%TYPE;
21: l_scores ar_cmgt_score_dtls.scores%TYPE;
22: l_weight ar_cmgt_score_weights.weight%TYPE;
23: l_data_point_type VARCHAR2(255);
24: l_data_point_value ar_cmgt_cf_dtls.data_point_value%type;
25: l_date_format VARCHAR2(255);
26: NULL_ZERO_CONVR_IND VARCHAR2(1);

Line 179: AR_CMGT_SCORE_WEIGHTS weight

175: -- the query.
176: SELECT score.scores, NVL(weight.weight,0)
177: INTO l_scores, l_weight
178: FROM ar_cmgt_score_dtls score,
179: AR_CMGT_SCORE_WEIGHTS weight
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

Line 242: AR_CMGT_SCORE_WEIGHTS weight

238:
239: SELECT score.scores, NVL(weight.weight,0)
240: INTO l_scores, l_weight
241: FROM ar_cmgt_score_dtls score,
242: AR_CMGT_SCORE_WEIGHTS weight
243: WHERE score.score_model_id = p_score_model_id
244: AND score.data_point_id = p_data_point_id
245: AND score.score_model_id = weight.score_model_id
246: AND score.data_point_id = weight.data_point_id

Line 300: AR_CMGT_SCORE_WEIGHTS weight

296:
297: SELECT score.scores, NVL(weight.weight,0)
298: INTO l_scores, l_weight
299: FROM ar_cmgt_score_dtls score,
300: AR_CMGT_SCORE_WEIGHTS weight
301: WHERE score.score_model_id = p_score_model_id
302: AND score.data_point_id = p_data_point_id
303: AND score.score_model_id = weight.score_model_id
304: AND score.data_point_id = weight.data_point_id