APPS.AR_CMGT_WF_ENGINE dependencies on AR_CMGT_AUTO_RULES

Line 2199: l_auto_rules_id ar_cmgt_auto_rules.auto_rules_id%type;

2195: funcmode in varchar2,
2196: resultout out NOCOPY varchar2) IS
2197:
2198: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
2199: l_auto_rules_id ar_cmgt_auto_rules.auto_rules_id%type;
2200: l_score_model_id_1 ar_cmgt_scores.score_model_id%TYPE;
2201:
2202: BEGIN
2203: IF funcmode = 'RUN'

Line 2237: FROM ar_cmgt_auto_rules

2233: END;
2234: BEGIN
2235: SELECT auto_rules_id
2236: INTO l_auto_rules_id
2237: FROM ar_cmgt_auto_rules
2238: WHERE score_model_id = l_score_model_id
2239: AND submit_flag = 'Y'
2240: AND TRUNC(sysdate) between TRUNC(start_date) and TRUNC(nvl(end_date,SYSDATE));
2241:

Line 4748: l_auto_rules_id ar_cmgt_auto_rules.auto_rules_id%type;

4744: l_resultout VARCHAR2(1);
4745: l_errmsg VARCHAR2(32767);
4746: l_credit_limit NUMBER := 0;
4747: insert_failure EXCEPTION;
4748: l_auto_rules_id ar_cmgt_auto_rules.auto_rules_id%type;
4749:
4750: --get score
4751:
4752: CURSOR GET_SCORE IS

Line 4770: FROM ar_cmgt_auto_rules

4766: --get auto rule id
4767:
4768: CURSOR get_auto_id IS
4769: SELECT auto_rules_id
4770: FROM ar_cmgt_auto_rules
4771: WHERE score_model_id=l_score_model_id
4772: AND Trunc(SYSDATE) BETWEEN Trunc(start_date) AND Trunc(Nvl(end_date,SYSDATE))
4773: AND submit_flag='Y';
4774: