[Home] [Help]
487: WHERE TASK_ID = P_TASK_ID;
488:
489: SELECT JTF_NOTE_ID
490: INTO l_note_id
491: FROM JTF_NOTES_B
492: WHERE SOURCE_OBJECT_ID = p_task_id
493: AND SOURCE_OBJECT_CODE = 'TASK'
494: AND ROWNUM = 1;
495:
664: COMMENTS IN VARCHAR2) IS
665:
666: CURSOR jtf_note_id_cursor IS
667: SELECT JTF_NOTE_ID
668: FROM JTF_NOTES_B
669: WHERE SOURCE_OBJECT_CODE = 'PARTY'
670: AND SOURCE_OBJECT_ID = PARTY_ID
671: ORDER BY 1;
672: