APPS.AHL_LTP_SPACE_ASSIGN_PVT dependencies on AHL_SPACES_VL

Line 198: AHL_VISITS_VL VST,ahl_spaces_vl SPA

194: cursor c_validate_space_dates (vst_id IN NUMBER)
195: IS
196: select SPA.SPACE_NAME SPACE_NAME,VST.start_date_time, start_from, VST.close_date_time, end_to
197: from ahl_space_assignments SPASSIGN,
198: AHL_VISITS_VL VST,ahl_spaces_vl SPA
199: WHERE
200: VST.VISIT_ID = SPASSIGN.VISIT_ID
201: AND SPA.SPACE_ID = SPASSIGN.SPACE_ID
202: AND

Line 450: FROM AHL_SPACES_VL

446: IF (p_space_name IS NOT NULL)
447: THEN
448: SELECT space_id
449: INTO x_space_id
450: FROM AHL_SPACES_VL
451: WHERE space_name = p_space_name;
452: ELSE
453: SELECT space_id
454: INTO x_space_id

Line 455: FROM AHL_SPACES_VL

451: WHERE space_name = p_space_name;
452: ELSE
453: SELECT space_id
454: INTO x_space_id
455: FROM AHL_SPACES_VL
456: WHERE SPACE_ID = p_space_id;
457: END IF;
458: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
459: EXCEPTION