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:
Line 668: FROM JTF_NOTES_B
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: