APPS.AR_CMGT_SCORING_ENGINE dependencies on AR_CMGT_SCORES

Line 124: FROM AR_CMGT_SCORES

120: BEGIN
121:
122: SELECT NULL_ZERO_FLAG
123: INTO NULL_ZERO_CONVR_IND
124: FROM AR_CMGT_SCORES
125: WHERE SCORE_MODEL_ID = p_score_model_id;
126:
127: IF pg_debug = 'Y'
128: THEN

Line 392: FROM AR_CMGT_SCORES

388: -- So, we include the currency equality check only if the flag is not
389: -- set (Bug 8627463) -- Start
390: SELECT NVL(SKIP_CURRENCY_TEST_FLAG, 'N')
391: INTO l_skip_currency_flag
392: FROM AR_CMGT_SCORES
393: WHERE SCORE_MODEL_ID = p_score_model_id;
394:
395: IF (l_skip_currency_flag = 'N') THEN
396: SELECT 'X'

Line 398: FROM ar_cmgt_scores score, ar_cmgt_case_folders case1

394:
395: IF (l_skip_currency_flag = 'N') THEN
396: SELECT 'X'
397: INTO l_result
398: FROM ar_cmgt_scores score, ar_cmgt_case_folders case1
399: WHERE case1.case_folder_id = p_case_folder_id
400: AND score.score_model_id = p_score_model_id
401: AND case1.limit_currency = score.currency
402: AND trunc(sysdate) between trunc(score.start_date) and

Line 411: FROM ar_cmgt_scores score, ar_cmgt_case_folders case1

407: END IF;
408: ELSE
409: SELECT 'X'
410: INTO l_result
411: FROM ar_cmgt_scores score, ar_cmgt_case_folders case1
412: WHERE case1.case_folder_id = p_case_folder_id
413: AND score.score_model_id = p_score_model_id
414: AND trunc(sysdate) between trunc(score.start_date) and
415: nvl(trunc(score.end_date), trunc(sysdate));

Line 583: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;

579: p_resultout OUT NOCOPY VARCHAR2) IS
580:
581: l_data_point_value ar_cmgt_cf_dtls.data_point_value%TYPE;
582: l_data_point_id ar_cmgt_data_points_vl.data_point_id%TYPE;
583: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
584: l_total_score NUMBER := 0;
585: l_score NUMBER := 0;
586: l_updt_flg VARCHAR2(1);
587: l_category VARCHAR2(20);

Line 862: FROM AR_CMGT_SCORES

858: -- So, we include the currency equality check only if the flag is not
859: -- set (Bug 8627463) -- Start
860: SELECT NVL(SKIP_CURRENCY_TEST_FLAG, 'N')
861: INTO l_skip_currency_flag
862: FROM AR_CMGT_SCORES
863: WHERE SCORE_MODEL_ID = p_score_model_id;
864:
865: IF ( l_skip_currency_flag = 'N') THEN
866: SELECT 'X'

Line 868: FROM ar_cmgt_scores score, ar_cmgt_case_folders case1

864:
865: IF ( l_skip_currency_flag = 'N') THEN
866: SELECT 'X'
867: INTO l_result
868: FROM ar_cmgt_scores score, ar_cmgt_case_folders case1
869: WHERE case1.case_folder_id = p_case_folder_id
870: AND score.score_model_id = p_score_model_id
871: AND case1.limit_currency = score.currency
872: AND trunc(sysdate) between trunc(score.start_date) and

Line 877: FROM ar_cmgt_scores score, ar_cmgt_case_folders case1

873: nvl(trunc(score.end_date), trunc(sysdate));
874: ELSE
875: SELECT 'X'
876: INTO l_result
877: FROM ar_cmgt_scores score, ar_cmgt_case_folders case1
878: WHERE case1.case_folder_id = p_case_folder_id
879: AND score.score_model_id = p_score_model_id
880: AND trunc(sysdate) between trunc(score.start_date) and
881: nvl(trunc(score.end_date), trunc(sysdate));