DBA Data[Home] [Help]

APPS.AR_CMGT_WF_ENGINE dependencies on AR_CMGT_SCORE_DTLS

Line 2424: from ar_cmgt_score_dtls

2420: l_data_point_code ar_cmgt_data_points_b.data_point_code%type;
2421:
2422: CURSOR dp_id_collec IS
2423: select distinct data_point_id
2424: from ar_cmgt_score_dtls
2425: where score_model_id= l_score_model_id;
2426: BEGIN
2427: IF funcmode = 'RUN'
2428: THEN

Line 2500: FROM ar_cmgt_score_dtls score,

2496: BEGIN
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

Line 4659: from ar_cmgt_score_dtls sc, ar_cmgt_data_points_vl dp

4655: UNEXP_ERROR EXCEPTION;
4656:
4657: CURSOR dp_id_collec IS
4658: select sc.data_point_id, dp.data_point_code
4659: from ar_cmgt_score_dtls sc, ar_cmgt_data_points_vl dp
4660: where sc.score_model_id= l_score_model_id
4661: AND sc.data_point_id = dp.data_point_id
4662: AND dp.data_point_code = 'OCM_EXTERNAL_SCORE';
4663: