APPS.AHL_AVF_OPER_VSTS_PVT dependencies on AHL_VISIT_TYPES_VL
Line 4673: select estimated_duration from ahl_visit_types_vl
4669:
4670: -- Bug 14336467 :: PRAKKUM :: 12/07/2012
4671: -- Cursor to get visit type duration
4672: CURSOR get_visit_type_dur(c_vst_type_code IN VARCHAR2, c_mc_id IN NUMBER) IS 4673: select estimated_duration from ahl_visit_types_vl 4674: where
4675: visit_type_code = c_vst_type_code
4676: and mc_id = c_mc_id
4677: and status_code = 'COMPLETE';