APPS.AHL_LTP_SPACE_ASSIGN_PVT dependencies on AHL_VISITS_B

Line 760: FROM ahl_visits_b

756: SELECT visit_type_code,
757: inventory_item_id,
758: trunc(start_date_time) start_date_time,
759: trunc(close_date_time)
760: FROM ahl_visits_b
761: WHERE visit_id = c_visit_id;
762: --
763: CURSOR space_available_cur(c_space_id IN NUMBER)
764: IS

Line 2118: FROM AHL_VISITS_B

2114: IS
2115: SELECT visit_id,
2116: object_version_number,
2117: status_code
2118: FROM AHL_VISITS_B
2119: WHERE VISIT_ID = c_visit_id;
2120:
2121: -- anraj: commented, issue number 144
2122: -- To Check space assignments having different org

Line 2733: FROM AHL_VISITS_B

2729: CURSOR c_schedule_visit_cur (c_visit_id IN NUMBER)
2730: IS
2731: SELECT visit_id, status_code,
2732: object_version_number
2733: FROM AHL_VISITS_B
2734: WHERE VISIT_ID = c_visit_id;
2735: --
2736: /*
2737: CURSOR c_space_assign_cur (c_visit_id IN NUMBER)

Line 2911: UPDATE AHL_VISITS_B

2907: /* changes made by mpothuku on 12/20/04 for calling the VWP API to make the visit update instead of directly
2908: updating the visit. */
2909: -- Changes by mpothuku start
2910: /*
2911: UPDATE AHL_VISITS_B
2912: SET organization_id = NULL,
2913: department_id = NULL,
2914: start_date_time = NULL,
2915: close_date_time = NULL,