DBA Data[Home] [Help]

APPS.AR_CMGT_WF_ENGINE dependencies on AR_CMGT_AUTO_RECOMMENDS

Line 2502: FROM ar_cmgt_auto_recommends a, ar_cmgt_auto_rule_dtls b

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;

Line 4270: FROM ar_cmgt_auto_recommends a, ar_cmgt_auto_rule_dtls b

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;