[Home] [Help]
648: PROCEDURE notes(p_contract_id IN NUMBER,
649: o_notes OUT NOCOPY VARCHAR2
650: ) IS
651: CURSOR notes IS
652: SELECT notes,last_update_date FROM jtf_notes_vl
653: WHERE source_object_id = p_contract_id
654: AND SOURCE_OBJECT_CODE = 'OKC_K_HEADER'
655: ORDER BY last_update_date DESC;
656: l_date DATE;