APPS.AR_CMGT_WF_ENGINE dependencies on AR_CMGT_AUTO_RULE_DTLS

Line 1957: l_override_checklist ar_cmgt_auto_rule_dtls.override_checklist_flag%type;

1953: resultout out NOCOPY varchar2) IS
1954:
1955: l_score NUMBER;
1956: l_auto_rules_id NUMBER;
1957: l_override_checklist ar_cmgt_auto_rule_dtls.override_checklist_flag%type;
1958: l_skip_approval ar_cmgt_auto_rule_dtls.skip_approval_flag%type;
1959: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
1960: BEGIN
1961: IF funcmode = 'RUN'

Line 1958: l_skip_approval ar_cmgt_auto_rule_dtls.skip_approval_flag%type;

1954:
1955: l_score NUMBER;
1956: l_auto_rules_id NUMBER;
1957: l_override_checklist ar_cmgt_auto_rule_dtls.override_checklist_flag%type;
1958: l_skip_approval ar_cmgt_auto_rule_dtls.skip_approval_flag%type;
1959: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
1960: BEGIN
1961: IF funcmode = 'RUN'
1962: THEN

Line 1982: FROM ar_cmgt_auto_rule_dtls

1978:
1979: BEGIN
1980: SELECT override_checklist_flag, skip_approval_flag
1981: INTO l_override_checklist, l_skip_approval
1982: FROM ar_cmgt_auto_rule_dtls
1983: WHERE auto_rules_id = l_auto_rules_id
1984: AND l_score between credit_score_low and credit_score_high
1985: AND currency = l_currency;
1986:

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;