DBA Data[Home] [Help]

APPS.AR_CMGT_REASSIGN_CONC dependencies on AR_CMGT_CASE_FOLDERS

Line 62: UPDATE ar_cmgt_case_folders

58: THEN
59:
60: --Update pending case folders
61: BEGIN
62: UPDATE ar_cmgt_case_folders
63: SET credit_analyst_id = l_credit_analyst_id_to
64: WHERE credit_analyst_id = l_credit_analyst_id_from
65: AND status in ('CREATED','SAVED');
66: EXCEPTION

Line 98: UPDATE ar_cmgt_case_folders

94: END IF;
95:
96: --Update pending case folders
97: BEGIN
98: UPDATE ar_cmgt_case_folders
99: SET credit_analyst_id = l_credit_analyst_id_to
100: WHERE credit_analyst_id = l_credit_analyst_id_from
101: AND creation_date_time between NVL(l_start_date,creation_date_time)
102: AND NVL(l_end_date,creation_date_time)