APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on AHL_VISITS_VL

Line 494: SELECT * FROM ahl_visits_vl

490: l_price_list_active_start_date DATE;
491: l_price_list_active_end_date DATE;
492:
493: CURSOR update_visit_csr(p_visit_id IN NUMBER)IS
494: SELECT * FROM ahl_visits_vl
495: WHERE visit_id = p_visit_id
496: FOR UPDATE OF object_version_number;
497: visit_rec update_visit_csr%ROWTYPE;
498:

Line 1484: SELECT * FROM ahl_visits_vl

1480: AND VST.task_type_code = 'UNASSOCIATED';
1481:
1482:
1483: CURSOR update_visit_csr(p_visit_id IN NUMBER)IS
1484: SELECT * FROM ahl_visits_vl
1485: WHERE visit_id = p_visit_id
1486: FOR UPDATE OF object_version_number;
1487:
1488: visit_rec update_visit_csr%ROWTYPE;