APPS.AR_CMGT_WF_ENGINE dependencies on AR_CMGT_CF_DTLS

Line 356: FROM ar_cmgt_check_list_dtls a, ar_cmgt_cf_dtls b,

352: END IF;
353: l_check_list_id := p_check_list_id;
354: BEGIN
355: SELECT 1 into l_cnt
356: FROM ar_cmgt_check_list_dtls a, ar_cmgt_cf_dtls b,
357: ar_cmgt_data_points_vl dp
358: WHERE a.check_list_id = l_check_list_id
359: AND b.case_folder_id = p_case_folder_id
360: AND a.data_point_id = b.data_point_id

Line 1975: delete ar_cmgt_cf_dtls

1971: itemkey => itemkey,
1972: aname => 'CASE_FOLDER_ID');
1973: delete ar_cmgt_case_folders
1974: WHERE case_folder_id = case_folder_id;
1975: delete ar_cmgt_cf_dtls
1976: WHERE case_folder_id = case_folder_id;
1977: END IF;
1978: EXCEPTION
1979: WHEN OTHERS

Line 2416: l_data_point_value ar_cmgt_cf_dtls.data_point_value%type;

2412:
2413: l_score_model_id NUMBER;
2414: l_case_folder_id NUMBER;
2415: l_data_point_id NUMBER;
2416: l_data_point_value ar_cmgt_cf_dtls.data_point_value%type;
2417: l_data_point_type VARCHAR2(255);
2418: l_null_zero_flag VARCHAR2(1);
2419: l_success_flg VARCHAR2(1);
2420: l_data_point_code ar_cmgt_data_points_b.data_point_code%type;

Line 2501: ar_cmgt_cf_dtls case1

2497:
2498: SELECT case1.data_point_value, case1.data_point_id
2499: INTO l_data_point_value, l_data_point_id
2500: FROM ar_cmgt_score_dtls score,
2501: ar_cmgt_cf_dtls case1
2502: WHERE score.score_model_id = l_score_model_id
2503: AND case1.case_folder_id = l_case_folder_id
2504: AND score.data_point_id = case1.data_point_id
2505: AND score.data_point_id = dp_id_collec_rec.data_point_id

Line 3553: FROM ar_cmgt_cf_dtls cfd

3549:
3550: BEGIN
3551: SELECT DECODE(to_number(NVL(cfd.data_point_value,'1')),0,1,NVL(cfd.data_point_value,'1'))
3552: INTO l_exposure
3553: FROM ar_cmgt_cf_dtls cfd
3554: WHERE cfd.case_folder_id = l_case_folder_id
3555: AND cfd.data_point_id = 34;
3556: EXCEPTION
3557: WHEN others THEN

Line 4643: l_data_point_value ar_cmgt_cf_dtls.data_point_value%type;

4639:
4640: l_score_model_id NUMBER;
4641: l_case_folder_id NUMBER;
4642: l_data_point_id NUMBER;
4643: l_data_point_value ar_cmgt_cf_dtls.data_point_value%type;
4644: l_data_point_type VARCHAR2(255);
4645: l_null_zero_flag VARCHAR2(1);
4646: l_success_flg VARCHAR2(1);
4647: l_data_point_name AR_CMGT_SCORABLE_DATA_POINTS_V.DATA_POINT_NAME%type;

Line 4754: FROM AR_CMGT_CF_DTLS

4750: --get score
4751:
4752: CURSOR GET_SCORE IS
4753: SELECT sum(nvl(SCORE,0))
4754: FROM AR_CMGT_CF_DTLS
4755: WHERE CASE_FOLDER_ID=p_cf_id;
4756:
4757:
4758: --get detailz