201: WHERE batch_id = l_doc_id;
202: ELSIF l_doc_type in ('PICY','PIPH','ADJI','ADJR','CREI','CRER','TRNI','TRNR') then
203: SELECT journal_no
204: INTO l_doc_no 205: FROM ic_jrnl_mst 206: WHERE journal_id = l_doc_id;
207: END IF;
208: /* End Bug#2250274*/
209: