APPS.AR_CMGT_SCORING_ENGINE dependencies on AR_CMGT_SCORES

Line 104: FROM AR_CMGT_SCORES

100: BEGIN
101:
102: SELECT NULL_ZERO_FLAG
103: INTO NULL_ZERO_CONVR_IND
104: FROM AR_CMGT_SCORES
105: WHERE SCORE_MODEL_ID = p_score_model_id;
106:
107: EXCEPTION
108: WHEN NO_DATA_FOUND THEN

Line 302: FROM ar_cmgt_scores score, ar_cmgt_case_folders case1

298: END IF;
299: BEGIN
300: SELECT 'X'
301: INTO l_result
302: FROM ar_cmgt_scores score, ar_cmgt_case_folders case1
303: WHERE case1.case_folder_id = p_case_folder_id
304: AND score.score_model_id = p_score_model_id
305: AND case1.limit_currency = score.currency
306: AND trunc(sysdate) between trunc(score.start_date) and

Line 463: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;

459: p_resultout OUT NOCOPY VARCHAR2) IS
460:
461: l_data_point_value ar_cmgt_cf_dtls.data_point_value%TYPE;
462: l_data_point_id ar_cmgt_data_points_vl.data_point_id%TYPE;
463: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
464: l_total_score NUMBER := 0;
465: l_score NUMBER := 0;
466: l_updt_flg VARCHAR2(1);
467: l_category VARCHAR2(20);

Line 745: FROM ar_cmgt_scores score, ar_cmgt_case_folders case1

741: -- raise an error. Bug 3624543
742: BEGIN
743: SELECT 'X'
744: INTO l_result
745: FROM ar_cmgt_scores score, ar_cmgt_case_folders case1
746: WHERE case1.case_folder_id = p_case_folder_id
747: AND score.score_model_id = p_score_model_id
748: AND case1.limit_currency = score.currency
749: AND trunc(sysdate) between trunc(score.start_date) and