250: AND batch_no = c_batch_no;
251:
252: CURSOR c_sessionid is
253: SELECT userenv('sessionid') sesid 254: FROM dual; 255:
256: -- Cursor to pick the History Rows for a given Person ID
257: CURSOR c_person_history(p_person_id NUMBER) IS
258: SELECT *