[Home] [Help]
249:
250: Cursor get_visit_type_duration(c_visit_type_code IN VARCHAR2, c_mc_id IN NUMBER)
251: IS
252: SELECT estimated_duration
253: FROM ahl_visit_types_b
254: WHERE visit_type_code = c_visit_type_code
255: AND mc_id = c_mc_id
256: AND status_code = 'COMPLETE';
257:
1603:
1604: Cursor get_visit_type_duration(c_visit_type_code IN VARCHAR2, c_mc_id IN NUMBER)
1605: IS
1606: SELECT estimated_duration
1607: FROM ahl_visit_types_b
1608: WHERE visit_type_code = c_visit_type_code
1609: AND mc_id = c_mc_id
1610: AND status_code = 'COMPLETE';
1611:
1663: --To get visit type duration of a given visit
1664: --Modified the below cursor by tchimira as a fix for issue 1 in the bug 13777327 on 01-Mar-2012
1665: CURSOR c_Visit_type_dur(c_visit_id IN NUMBER) IS
1666: SELECT vtyp.estimated_duration
1667: FROM ahl_visit_types_b vtyp, ahl_visits_b visit, ahl_unit_config_headers unit, ahl_mc_headers_b mc
1668: WHERE visit.visit_id = c_visit_id
1669: AND vtyp.visit_type_code = visit.visit_type_code
1670: AND unit.csi_item_instance_id = visit.item_instance_id
1671: AND unit.master_config_id = mc.mc_header_id
4132: -- Cursor to find visit type duration
4133: Cursor get_visit_type_duration(c_visit_type_code IN VARCHAR2, c_mc_id IN NUMBER)
4134: IS
4135: SELECT estimated_duration
4136: FROM ahl_visit_types_b
4137: WHERE visit_type_code = c_visit_type_code
4138: AND mc_id = c_mc_id
4139: AND status_code = 'COMPLETE';
4140:
4392: -- Cursor to find visit type duration
4393: Cursor get_visit_type_duration(c_visit_type_code IN VARCHAR2, c_mc_id IN NUMBER)
4394: IS
4395: SELECT estimated_duration
4396: FROM ahl_visit_types_b
4397: WHERE visit_type_code = c_visit_type_code
4398: AND mc_id = c_mc_id
4399: AND status_code = 'COMPLETE';
4400: