APPS.AHL_APPR_SPACE_CAPB_PVT dependencies on AHL_SPACE_ASSIGNMENTS

Line 600: FROM AHL_SPACE_ASSIGNMENTS

596: IF (p_space_rec.space_id <> FND_API.G_MISS_NUM AND
597: p_space_rec.space_id IS NOT NULL) THEN
598: --
599: SELECT space_id INTO l_space_id
600: FROM AHL_SPACE_ASSIGNMENTS
601: WHERE space_id = p_space_rec.space_id;
602: --
603: IF l_space_id IS NOT NULL THEN
604: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_ASSIGN_EXISTS');

Line 1566: AHL_SPACE_ASSIGNMENTS

1562: --
1563: CURSOR c_space_visit_cur (c_space_id IN NUMBER)
1564: IS
1565: SELECT visit_id FROM
1566: AHL_SPACE_ASSIGNMENTS
1567: WHERE space_id = c_space_id;
1568: --
1569: CURSOR get_status_cur(c_visit_id IN NUMBER)
1570: IS

Line 3197: FROM ahl_space_assignments

3193: -- Get space assignment
3194: CURSOR space_assign_cur (c_space_id IN NUMBER)
3195: IS
3196: SELECT visit_id
3197: FROM ahl_space_assignments
3198: WHERE space_id = c_space_id;
3199: --
3200: CURSOR check_space_capb_cur (c_visit_id IN NUMBER,
3201: c_visit_type IN VARCHAR2,