APPS.AR_CMGT_SCORING_ENGINE dependencies on AR_CMGT_CASE_FOLDERS

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 617: FROM ar_cmgt_case_folders data1, ar_cmgt_case_folders case1

613: THEN
614: BEGIN
615: SELECT data1.case_folder_id
616: INTO g_data_case_folder_id
617: FROM ar_cmgt_case_folders data1, ar_cmgt_case_folders case1
618: WHERE data1.type = 'DATA'
619: and case1.case_folder_id = p_case_folder_id
620: and case1.party_id = data1.party_id
621: and case1.cust_account_id = data1.cust_account_id

Line 761: ar_cmgt_case_folders case1

757:
758: CURSOR cScoreDataPoint IS
759: SELECT distinct score.data_point_id, score.score_model_id
760: FROM ar_cmgt_score_dtls score,
761: ar_cmgt_case_folders case1
762: WHERE case_folder_id = p_case_folder_id
763: AND case1.score_model_id = score.score_model_id;
764: l_total_score NUMBER := 0;
765:

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));

Line 916: /* UPDATE ar_cmgt_case_folders

912: * Changes end------------------------------------------------------------------
913: * bug#5007954
914: */
915: -- update the scoring model Id in case folder table
916: /* UPDATE ar_cmgt_case_folders
917: set score_model_id = p_score_model_id,
918: last_updated = SYSDATE,
919: last_update_date = sysdate,
920: last_updated_by = fnd_global.user_id,