389: l_count := 1;
390: BEGIN
391: SELECT CREATED_BY
392: INTO l_released_by
393: FROM ar_cmgt_cf_recommends
394: WHERE credit_request_id = l_credit_request_id
395: AND credit_recommendation = 'REMOVE_ORDER_HOLD'
396: AND status = 'I'
397: AND CASE_FOLDER_ID = l_CASE_FOLDER_ID;
401: END;
402: /*
403: SELECT COUNT(1)
404: INTO l_count
405: FROM ar_cmgt_cf_recommends
406: WHERE credit_request_id = l_credit_request_id
407: AND credit_recommendation = 'REMOVE_ORDER_HOLD'
408: AND status = 'I';*/
409: --bug# 8617023 end