DBA Data[Home] [Help]

APPS.AR_CMGT_WF_ENGINE dependencies on AR_CMGT_SCORE_DTLS

Line 2095: from ar_cmgt_score_dtls

2091: l_data_point_code ar_cmgt_data_points_b.data_point_code%type;
2092:
2093: CURSOR dp_id_collec IS
2094: select distinct data_point_id
2095: from ar_cmgt_score_dtls
2096: where score_model_id= l_score_model_id;
2097: BEGIN
2098: IF funcmode = 'RUN'
2099: THEN

Line 2171: FROM ar_cmgt_score_dtls score,

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

Line 4150: from ar_cmgt_score_dtls sc, ar_cmgt_data_points_vl dp

4146: UNEXP_ERROR EXCEPTION;
4147:
4148: CURSOR dp_id_collec IS
4149: select sc.data_point_id, dp.data_point_code
4150: from ar_cmgt_score_dtls sc, ar_cmgt_data_points_vl dp
4151: where sc.score_model_id= l_score_model_id
4152: AND sc.data_point_id = dp.data_point_id
4153: AND dp.data_point_code = 'OCM_EXTERNAL_SCORE';
4154: