APPS.AHL_APPR_SPACE_UNAVL_PVT dependencies on AHL_SPACES_VL

Line 158: FROM AHL_SPACES_VL

154: IF (p_space_id IS NOT NULL)
155: THEN
156: SELECT space_id
157: INTO x_space_id
158: FROM AHL_SPACES_VL
159: WHERE space_id = p_space_id;
160: ELSE
161: SELECT space_id
162: INTO x_space_id

Line 163: FROM AHL_SPACES_VL

159: WHERE space_id = p_space_id;
160: ELSE
161: SELECT space_id
162: INTO x_space_id
163: FROM AHL_SPACES_VL
164: WHERE SPACE_NAME = p_space_name;
165: END IF;
166: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
167: EXCEPTION

Line 457: l_table_name := 'AHL_SPACES_VL';

453:
454: -- Check FK parameter: SPACE_ID
455: IF p_space_restriction_rec.SPACE_ID <> Fnd_Api.g_miss_num
456: THEN
457: l_table_name := 'AHL_SPACES_VL';
458: l_pk_name := 'SPACE_ID';
459: l_pk_value := p_space_restriction_rec.SPACE_ID;
460: IF Ahl_Utility_Pvt.Check_FK_Exists (
461: p_table_name => l_table_name,