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 151: AR_CMGT_SCORE_WEIGHTS weight

147:
148: SELECT score.scores, NVL(weight.weight,0)
149: INTO l_scores, l_weight
150: FROM ar_cmgt_score_dtls score,
151: AR_CMGT_SCORE_WEIGHTS weight
152: WHERE score.score_model_id = p_score_model_id
153: AND score.data_point_id = p_data_point_id
154: AND score.score_model_id = weight.score_model_id
155: AND score.data_point_id = weight.data_point_id

Line 196: AR_CMGT_SCORE_WEIGHTS weight

192: BEGIN
193: SELECT score.scores, NVL(weight.weight,0)
194: INTO l_scores, l_weight
195: FROM ar_cmgt_score_dtls score,
196: AR_CMGT_SCORE_WEIGHTS weight
197: WHERE score.score_model_id = p_score_model_id
198: AND score.data_point_id = p_data_point_id
199: AND score.score_model_id = weight.score_model_id
200: AND score.data_point_id = weight.data_point_id

Line 236: AR_CMGT_SCORE_WEIGHTS weight

232: BEGIN
233: SELECT score.scores, NVL(weight.weight,0)
234: INTO l_scores, l_weight
235: FROM ar_cmgt_score_dtls score,
236: AR_CMGT_SCORE_WEIGHTS weight
237: WHERE score.score_model_id = p_score_model_id
238: AND score.data_point_id = p_data_point_id
239: AND score.score_model_id = weight.score_model_id
240: AND score.data_point_id = weight.data_point_id