DBA Data[Home] [Help]

APPS.OKL_CS_LC_CONTRACT_PVT dependencies on JTF_NOTES_VL

Line 652: SELECT notes,last_update_date FROM jtf_notes_vl

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;