APPS.AR_CMGT_SCORING_ENGINE dependencies on AR_CMGT_SCORABLE_DATA_POINTS_V

Line 76: FROM AR_CMGT_SCORABLE_DATA_POINTS_V

72:
73: BEGIN
74: SELECT RETURN_DATA_TYPE,RETURN_DATE_FORMAT
75: INTO l_data_point_type,l_date_format
76: FROM AR_CMGT_SCORABLE_DATA_POINTS_V
77: WHERE DATA_POINT_ID = p_data_point_id;
78: --we don not need to check for scorable data points
79: --because the score model will contain only scorable
80: --data points.

Line 441: FROM ar_cmgt_scorable_data_points_v v

437:
438: /* 9342120 - Added function_name directly to view */
439: SELECT v.data_point_category, v.function_name
440: INTO l_category, l_function_name
441: FROM ar_cmgt_scorable_data_points_v v
442: WHERE v.data_point_id = p_data_point_id;
443:
444: BEGIN
445:

Line 595: FROM ar_cmgt_scorable_data_points_v v

591:
592: /* 9342120 - Added function_name to view */
593: SELECT v.data_point_category, v.function_name
594: INTO l_category, l_function_name
595: FROM ar_cmgt_scorable_data_points_v v
596: where v.data_point_id = p_data_point_id;
597:
598: IF l_category='ADDITIONAL'
599: AND l_function_name IS NULL

Line 654: FROM ar_cmgt_scorable_data_points_v sdp,

650: /* 9342120 - using scorable_data_points_v to
651: accomodate DNB datapoints */
652: SELECT cfd.data_point_value
653: INTO l_data_point_value
654: FROM ar_cmgt_scorable_data_points_v sdp,
655: ar_cmgt_cf_dtls cfd
656: WHERE cfd.case_folder_id = p_case_folder_id
657: AND sdp.data_point_id = cfd.data_point_id (+)
658: AND sdp.data_point_id = p_data_point_id;