2498:
2499: CURSOR c_auto_reco IS
2500: SELECT a.credit_recommendation, a.recommendation_value1,
2501: a.recommendation_value2
2502: FROM ar_cmgt_auto_recommends a, ar_cmgt_auto_rule_dtls b
2503: WHERE a.auto_rule_details_id = b.auto_rule_details_id
2504: AND l_score between b.credit_score_low and b.credit_score_high
2505: AND a.credit_type = l_credit_type
2506: AND b.auto_rules_id = l_auto_rules_id;
4266:
4267: CURSOR c_auto_reco IS
4268: SELECT a.credit_recommendation, a.recommendation_value1,
4269: a.recommendation_value2
4270: FROM ar_cmgt_auto_recommends a, ar_cmgt_auto_rule_dtls b
4271: WHERE a.auto_rule_details_id = b.auto_rule_details_id
4272: AND l_score between b.credit_score_low and b.credit_score_high
4273: AND a.credit_type = l_credit_type
4274: AND b.auto_rules_id = l_auto_rules_id;