APPS.AR_CMGT_SCORING_ENGINE dependencies on AR_CMGT_CASE_FOLDERS

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

490: THEN
491: BEGIN
492: SELECT data1.case_folder_id
493: INTO g_data_case_folder_id
494: FROM ar_cmgt_case_folders data1, ar_cmgt_case_folders case1
495: WHERE data1.type = 'DATA'
496: and case1.case_folder_id = p_case_folder_id
497: and case1.party_id = data1.party_id
498: and case1.cust_account_id = data1.cust_account_id

Line 651: ar_cmgt_case_folders case1

647:
648: CURSOR cScoreDataPoint IS
649: SELECT distinct score.data_point_id, score.score_model_id
650: FROM ar_cmgt_score_dtls score,
651: ar_cmgt_case_folders case1
652: WHERE case_folder_id = p_case_folder_id
653: AND case1.score_model_id = score.score_model_id;
654: l_total_score NUMBER := 0;
655:

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

Line 782: /* UPDATE ar_cmgt_case_folders

778: * Changes end------------------------------------------------------------------
779: * bug#5007954
780: */
781: -- update the scoring model Id in case folder table
782: /* UPDATE ar_cmgt_case_folders
783: set score_model_id = p_score_model_id,
784: last_updated = SYSDATE,
785: last_update_date = sysdate,
786: last_updated_by = fnd_global.user_id,