DBA Data[Home] [Help]

APPS.OKL_CS_LC_CONTRACT_PVT dependencies on JTF_NOTES_VL

Line 614: SELECT notes,last_update_date FROM jtf_notes_vl

610: PROCEDURE notes(p_contract_id IN NUMBER,
611: o_notes OUT NOCOPY VARCHAR2
612: ) IS
613: CURSOR notes IS
614: SELECT notes,last_update_date FROM jtf_notes_vl
615: WHERE source_object_id = p_contract_id
616: AND SOURCE_OBJECT_CODE = 'OKC_K_HEADER'
617: ORDER BY last_update_date DESC;
618: l_date DATE;