APPS.AR_CMGT_WF_ENGINE dependencies on AR_CMGT_DATA_POINTS_VL

Line 167: l_data_point_id ar_cmgt_data_points_vl.data_point_id%type;

163: p_errmsg OUT NOCOPY VARCHAR2,
164: p_resultout OUT NOCOPY VARCHAR2 ) IS
165:
166: cnt NUMBER;
167: l_data_point_id ar_cmgt_data_points_vl.data_point_id%type;
168: CURSOR c_dnb_required_data IS
169: SELECT data_point_id
170: FROM ar_cmgt_check_list_dtls
171: WHERE data_point_id between 10000 and 20000

Line 336: ar_cmgt_data_points_vl dp

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
340: AND dp.data_point_id = a.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: