APPS.AHL_APPR_SPACE_CAPB_PVT dependencies on AHL_VISITS_B

Line 1571: SELECT status_code FROM AHL_VISITS_B

1567: WHERE space_id = c_space_id;
1568: --
1569: CURSOR get_status_cur(c_visit_id IN NUMBER)
1570: IS
1571: SELECT status_code FROM AHL_VISITS_B
1572: WHERE visit_id = c_visit_id;
1573:
1574: --
1575: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_SPACE';

Line 3204: SELECT 1 FROM ahl_visits_b

3200: CURSOR check_space_capb_cur (c_visit_id IN NUMBER,
3201: c_visit_type IN VARCHAR2,
3202: c_inventory_item_id IN NUMBER)
3203: IS
3204: SELECT 1 FROM ahl_visits_b
3205: WHERE visit_id = c_visit_id
3206: AND visit_type_code = c_visit_type
3207: AND inventory_item_id = c_inventory_item_id;
3208: --