443: l_price_list_active_start_date DATE;
444: l_price_list_active_end_date DATE;
445:
446: CURSOR update_visit_csr(p_visit_id IN NUMBER)IS
447: SELECT * FROM ahl_visits_vl
448: WHERE visit_id = p_visit_id
449: FOR UPDATE OF object_version_number;
450: visit_rec update_visit_csr%ROWTYPE;
451:
1411: AND VST.task_type_code = 'UNASSOCIATED';
1412:
1413:
1414: CURSOR update_visit_csr(p_visit_id IN NUMBER)IS
1415: SELECT * FROM ahl_visits_vl
1416: WHERE visit_id = p_visit_id
1417: FOR UPDATE OF object_version_number;
1418:
1419: visit_rec update_visit_csr%ROWTYPE;