128:
129: CURSOR l_last_run_date_csr
130: IS
131: SELECT nvl(last_run_date, (sysdate - 365*50))
132: FROM jtm_con_request_data
133: WHERE package_name = 'CSM_STATE_TRANSITION_EVENT_PKG'
134: AND procedure_name = 'REFRESH_ACC';
135:
136: BEGIN
145: Refresh_acc_ins(rec.USER_ID,rec.RESPONSIBILITY_ID);
146: END LOOP;
147:
148:
149: UPDATE jtm_con_request_data
150: SET last_run_date = sysdate
151: WHERE package_name = 'CSM_STATE_TRANSITION_EVENT_PKG'
152: AND procedure_name = 'REFRESH_ACC';
153: