APPS.AR_CMGT_WF_ENGINE dependencies on AR_CMGT_CF_DTLS

Line 335: FROM ar_cmgt_check_list_dtls a, ar_cmgt_cf_dtls b,

331: END IF;
332: l_check_list_id := p_check_list_id;
333: BEGIN
334: SELECT 1 into l_cnt
335: FROM ar_cmgt_check_list_dtls a, ar_cmgt_cf_dtls b,
336: ar_cmgt_data_points_vl dp
337: WHERE a.check_list_id = l_check_list_id
338: AND b.case_folder_id = p_case_folder_id
339: AND a.data_point_id = b.data_point_id

Line 1663: delete ar_cmgt_cf_dtls

1659: itemkey => itemkey,
1660: aname => 'CASE_FOLDER_ID');
1661: delete ar_cmgt_case_folders
1662: WHERE case_folder_id = case_folder_id;
1663: delete ar_cmgt_cf_dtls
1664: WHERE case_folder_id = case_folder_id;
1665: END IF;
1666: EXCEPTION
1667: WHEN OTHERS

Line 2087: l_data_point_value ar_cmgt_cf_dtls.data_point_value%type;

2083:
2084: l_score_model_id NUMBER;
2085: l_case_folder_id NUMBER;
2086: l_data_point_id NUMBER;
2087: l_data_point_value ar_cmgt_cf_dtls.data_point_value%type;
2088: l_data_point_type VARCHAR2(255);
2089: l_null_zero_flag VARCHAR2(1);
2090: l_success_flg VARCHAR2(1);
2091: l_data_point_code ar_cmgt_data_points_b.data_point_code%type;

Line 2172: ar_cmgt_cf_dtls case1

2168:
2169: SELECT case1.data_point_value, case1.data_point_id
2170: INTO l_data_point_value, l_data_point_id
2171: FROM ar_cmgt_score_dtls score,
2172: ar_cmgt_cf_dtls case1
2173: WHERE score.score_model_id = l_score_model_id
2174: AND case1.case_folder_id = l_case_folder_id
2175: AND score.data_point_id = case1.data_point_id
2176: AND score.data_point_id = dp_id_collec_rec.data_point_id

Line 3123: FROM ar_cmgt_cf_dtls cfd

3119:
3120: BEGIN
3121: SELECT DECODE(to_number(NVL(cfd.data_point_value,'1')),0,1,NVL(cfd.data_point_value,'1'))
3122: INTO l_exposure
3123: FROM ar_cmgt_cf_dtls cfd
3124: WHERE cfd.case_folder_id = l_case_folder_id
3125: AND cfd.data_point_id = 34;
3126: EXCEPTION
3127: WHEN others THEN

Line 4134: l_data_point_value ar_cmgt_cf_dtls.data_point_value%type;

4130:
4131: l_score_model_id NUMBER;
4132: l_case_folder_id NUMBER;
4133: l_data_point_id NUMBER;
4134: l_data_point_value ar_cmgt_cf_dtls.data_point_value%type;
4135: l_data_point_type VARCHAR2(255);
4136: l_null_zero_flag VARCHAR2(1);
4137: l_success_flg VARCHAR2(1);
4138: l_data_point_name AR_CMGT_SCORABLE_DATA_POINTS_V.DATA_POINT_NAME%type;

Line 4244: FROM AR_CMGT_CF_DTLS

4240: --get score
4241:
4242: CURSOR GET_SCORE IS
4243: SELECT sum(nvl(SCORE,0))
4244: FROM AR_CMGT_CF_DTLS
4245: WHERE CASE_FOLDER_ID=p_cf_id;
4246:
4247:
4248: --get detailz