DBA Data[Home] [Help]

APPS.AR_CMGT_WF_ENGINE dependencies on AR_CMGT_AUTO_RECOMMENDS

Line 2876: FROM ar_cmgt_auto_recommends a, ar_cmgt_auto_rule_dtls b

2872:
2873: CURSOR c_auto_reco IS
2874: SELECT a.credit_recommendation, a.recommendation_value1,
2875: a.recommendation_value2
2876: FROM ar_cmgt_auto_recommends a, ar_cmgt_auto_rule_dtls b
2877: WHERE a.auto_rule_details_id = b.auto_rule_details_id
2878: AND l_score between b.credit_score_low and b.credit_score_high
2879: AND a.credit_type = l_credit_type
2880: AND b.auto_rules_id = l_auto_rules_id;

Line 4780: FROM ar_cmgt_auto_recommends a, ar_cmgt_auto_rule_dtls b

4776:
4777: CURSOR c_auto_reco IS
4778: SELECT a.credit_recommendation, a.recommendation_value1,
4779: a.recommendation_value2
4780: FROM ar_cmgt_auto_recommends a, ar_cmgt_auto_rule_dtls b
4781: WHERE a.auto_rule_details_id = b.auto_rule_details_id
4782: AND l_score between b.credit_score_low and b.credit_score_high
4783: AND a.credit_type = l_credit_type
4784: AND b.auto_rules_id = l_auto_rules_id;