eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_CMGT_WF_ENGINE dependencies on AR_CMGT_AUTO_RULE_DTLS

Line 2269: l_override_checklist ar_cmgt_auto_rule_dtls.override_checklist_flag%type;

2265: resultout out NOCOPY varchar2) IS
2266:
2267: l_score NUMBER;
2268: l_auto_rules_id NUMBER;
2269: l_override_checklist ar_cmgt_auto_rule_dtls.override_checklist_flag%type;
2270: l_skip_approval ar_cmgt_auto_rule_dtls.skip_approval_flag%type;
2271: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
2272: l_trans_currency ar_cmgt_credit_requests.trx_currency%TYPE; -- Fixed for bug 9871620
2273: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE; -- Fixed for bug 9871620

Line 2270: l_skip_approval ar_cmgt_auto_rule_dtls.skip_approval_flag%type;

2266:
2267: l_score NUMBER;
2268: l_auto_rules_id NUMBER;
2269: l_override_checklist ar_cmgt_auto_rule_dtls.override_checklist_flag%type;
2270: l_skip_approval ar_cmgt_auto_rule_dtls.skip_approval_flag%type;
2271: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
2272: l_trans_currency ar_cmgt_credit_requests.trx_currency%TYPE; -- Fixed for bug 9871620
2273: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE; -- Fixed for bug 9871620
2274: BEGIN

Line 2312: FROM ar_cmgt_auto_rule_dtls

2308: -- Fixed for bug 9871620 - End
2309:
2310: SELECT override_checklist_flag, skip_approval_flag
2311: INTO l_override_checklist, l_skip_approval
2312: FROM ar_cmgt_auto_rule_dtls
2313: WHERE auto_rules_id = l_auto_rules_id
2314: AND l_score between credit_score_low and credit_score_high
2315: AND currency = l_trans_currency; -- Fixed for bug 9871620
2316:

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;