301: pjournal_no OUT NOCOPY VARCHAR2) IS
302:
303: CURSOR get_jrnl_no IS
304: SELECT journal_no 305: FROM ic_jrnl_mst 306: WHERE journal_id = pjournal_id;
307:
308: BEGIN
309: OPEN get_jrnl_no;
Line 409: FROM ic_jrnl_mst
405: pjrnl_comment OUT NOCOPY VARCHAR2) IS
406:
407: CURSOR get_jrnl_comment IS
408: SELECT journal_comment 409: FROM ic_jrnl_mst 410: WHERE journal_id = pjournal_id;
411:
412: BEGIN
413: OPEN get_jrnl_comment;