APPS.AR_CMGT_WF_ENGINE dependencies on AR_CMGT_AUTO_RULES

Line 1887: l_auto_rules_id ar_cmgt_auto_rules.auto_rules_id%type;

1883: funcmode in varchar2,
1884: resultout out NOCOPY varchar2) IS
1885:
1886: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
1887: l_auto_rules_id ar_cmgt_auto_rules.auto_rules_id%type;
1888: l_score_model_id_1 ar_cmgt_scores.score_model_id%TYPE;
1889:
1890: BEGIN
1891: IF funcmode = 'RUN'

Line 1925: FROM ar_cmgt_auto_rules

1921: END;
1922: BEGIN
1923: SELECT auto_rules_id
1924: INTO l_auto_rules_id
1925: FROM ar_cmgt_auto_rules
1926: WHERE score_model_id = l_score_model_id
1927: AND submit_flag = 'Y'
1928: AND TRUNC(sysdate) between TRUNC(start_date) and TRUNC(nvl(end_date,SYSDATE));
1929:

Line 4238: l_auto_rules_id ar_cmgt_auto_rules.auto_rules_id%type;

4234: l_resultout VARCHAR2(1);
4235: l_errmsg VARCHAR2(32767);
4236: l_credit_limit NUMBER := 0;
4237: insert_failure EXCEPTION;
4238: l_auto_rules_id ar_cmgt_auto_rules.auto_rules_id%type;
4239:
4240: --get score
4241:
4242: CURSOR GET_SCORE IS

Line 4260: FROM ar_cmgt_auto_rules

4256: --get auto rule id
4257:
4258: CURSOR get_auto_id IS
4259: SELECT auto_rules_id
4260: FROM ar_cmgt_auto_rules
4261: WHERE score_model_id=l_score_model_id
4262: AND Trunc(SYSDATE) BETWEEN Trunc(start_date) AND Trunc(Nvl(end_date,SYSDATE))
4263: AND submit_flag='Y';
4264: