APPS.AR_CMGT_WF_ENGINE dependencies on AR_CMGT_DATA_POINTS_VL

Line 188: l_data_point_id ar_cmgt_data_points_vl.data_point_id%type;

184: p_errmsg OUT NOCOPY VARCHAR2,
185: p_resultout OUT NOCOPY VARCHAR2 ) IS
186:
187: cnt NUMBER;
188: l_data_point_id ar_cmgt_data_points_vl.data_point_id%type;
189: CURSOR c_dnb_required_data IS
190: SELECT data_point_id
191: FROM ar_cmgt_check_list_dtls
192: WHERE data_point_id between 10000 and 20000

Line 357: ar_cmgt_data_points_vl dp

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