APPS.AHL_LTP_SPACE_ASSIGN_PVT dependencies on AHL_VISITS_B

Line 487: FROM ahl_visits_b

483: SELECT visit_type_code,
484: inventory_item_id,
485: trunc(start_date_time) start_date_time,
486: trunc(close_date_time)
487: FROM ahl_visits_b
488: WHERE visit_id = c_visit_id;
489: --
490: CURSOR space_available_cur(c_space_id IN NUMBER)
491: IS

Line 1708: FROM AHL_VISITS_B

1704: IS
1705: SELECT visit_id,
1706: object_version_number,
1707: status_code
1708: FROM AHL_VISITS_B
1709: WHERE VISIT_ID = c_visit_id;
1710:
1711: -- anraj: commented, issue number 144
1712: -- To Check space assignments having different org

Line 2323: FROM AHL_VISITS_B

2319: CURSOR c_schedule_visit_cur (c_visit_id IN NUMBER)
2320: IS
2321: SELECT visit_id, status_code,
2322: object_version_number
2323: FROM AHL_VISITS_B
2324: WHERE VISIT_ID = c_visit_id;
2325: --
2326: /*
2327: CURSOR c_space_assign_cur (c_visit_id IN NUMBER)

Line 2501: UPDATE AHL_VISITS_B

2497: /* changes made by mpothuku on 12/20/04 for calling the VWP API to make the visit update instead of directly
2498: updating the visit. */
2499: -- Changes by mpothuku start
2500: /*
2501: UPDATE AHL_VISITS_B
2502: SET organization_id = NULL,
2503: department_id = NULL,
2504: start_date_time = NULL,
2505: close_date_time = NULL,