DBA Data[Home] [Help]

APPS.AR_CMGT_REASSIGN_CONC dependencies on AR_CMGT_CREDIT_REQUESTS

Line 73: UPDATE ar_cmgt_credit_requests

69: END;
70:
71: --Update pending credit requests
72: BEGIN
73: UPDATE ar_cmgt_credit_requests
74: SET credit_analyst_id = l_credit_analyst_id_to
75: WHERE credit_analyst_id = l_credit_analyst_id_from
76: AND status in ('IN_PROCESS','SAVED','SUBMIT');
77: EXCEPTION

Line 111: UPDATE ar_cmgt_credit_requests

107: END;
108:
109: --Update pending credit requests
110: BEGIN
111: UPDATE ar_cmgt_credit_requests
112: SET credit_analyst_id = l_credit_analyst_id_to
113: WHERE credit_analyst_id = l_credit_analyst_id_from
114: AND creation_date between NVL(l_start_date,creation_date)
115: AND NVL(l_end_date,creation_date)