[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT dp.DATA_POINT_ID,
dp.DATA_POINT_CODE,
dp.DATA_POINT_NAME ,
dp.DATA_POINT_CATEGORY ,
dp.DESCRIPTION ,
dp.SCORABLE_FLAG ,
dp.APPLICATION_ID ,
dp.PACKAGE_NAME ,
dp.FUNCTION_NAME ,
dp.PARENT_DATA_POINT_ID ,
dp.DATA_POINT_SUB_CATEGORY ,
dp.FUNCTION_TYPE ,
dp.RETURN_DATA_TYPE ,
dp.RETURN_DATE_FORMAT
FROM ar_cmgt_data_points_vl dp,
ar_cmgt_check_lists chklist,
ar_cmgt_check_list_dtls chkdtls
WHERE chklist.credit_classification = p_credit_classification
AND chklist.review_type = p_review_type
AND sysdate between start_date and nvl(end_date, sysdate)
AND chklist.check_list_id = chkdtls.check_list_id
AND chkdtls.data_point_id = dp.data_point_id
AND dp.data_point_category = nvl(p_data_point_category, data_point_category)
AND dp.data_point_sub_category = nvl(p_data_point_sub_category, data_point_sub_category)
ORDER BY dp.DATA_POINT_NAME; -- Fix for bug 12359921
SELECT 'x' INTO l_check_flag
FROM ar_lookups
WHERE lookup_type = 'OCM_USER_DATA_POINT_CATEGORIES'
AND lookup_code = p_data_point_sub_category
AND enabled_flag = 'Y'
AND trunc(sysdate) between trunc(start_date_active)
and nvl(trunc(end_date_active), trunc(sysdate));
SELECT 'x' INTO l_check_flag
FROM ar_lookups
WHERE lookup_type = 'AR_CMGT_DATA_POINT_CATEGORY'
AND lookup_code = p_data_point_category
AND enabled_flag = 'Y'
AND trunc(sysdate) between trunc(start_date_active)
and nvl(trunc(end_date_active), trunc(sysdate));