6: l_credit_limit NUMBER;
7: BEGIN
8: SELECT recommendation_value2
9: INTO l_credit_limit
10: FROM ar_cmgt_cf_recommends
11: WHERE case_folder_id = transactionIdIn
12: AND credit_recommendation = 'CREDIT_LIMIT';
13:
14: return(l_credit_limit);
25: l_credit_limit NUMBER;
26: BEGIN
27: SELECT recommendation_value2
28: INTO l_credit_limit
29: FROM ar_cmgt_cf_recommends
30: WHERE case_folder_id = transactionIdIn
31: AND credit_recommendation = 'TXN_CREDIT_LIMIT';
32:
33: return(l_credit_limit);
62: l_credit_classification VARCHAR2(30);
63: BEGIN
64: SELECT recommendation_value1
65: INTO l_credit_classification
66: FROM ar_cmgt_cf_recommends
67: WHERE case_folder_id = transactionIdIn
68: AND credit_recommendation = 'CLASSIFICATION';
69:
70: return(l_credit_classification);