APPS.AHL_LTP_SPACE_ASSIGN_PVT dependencies on AHL_VISITS_VL

Line 52: select VISIT_ID, start_date_time as START_DATE, close_date_time as PLANNED_END_DATE from AHL_VISITS_VL

48: l_isValidationFailed BOOLEAN;
49:
50: -- cursor to get visit dates
51: CURSOR validate_with_visit_dets(p_visit_id IN NUMBER) IS
52: select VISIT_ID, start_date_time as START_DATE, close_date_time as PLANNED_END_DATE from AHL_VISITS_VL
53: where VISIT_ID = p_visit_id;
54:
55: l_visit_dets_rec validate_with_visit_dets%ROWTYPE;
56:

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 494: FROM AHL_VISITS_VL

490: IF (p_visit_id IS NOT NULL)
491: THEN
492: SELECT visit_id
493: INTO x_visit_id
494: FROM AHL_VISITS_VL
495: WHERE visit_id = p_visit_id;
496: ELSE
497: SELECT visit_id
498: INTO x_visit_id

Line 499: FROM AHL_VISITS_VL

495: WHERE visit_id = p_visit_id;
496: ELSE
497: SELECT visit_id
498: INTO x_visit_id
499: FROM AHL_VISITS_VL
500: WHERE visit_number = p_visit_number;
501: END IF;
502: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
503: EXCEPTION

Line 1866: ahl_visits_vl vt,

1862: sp.bom_department_id spdept_id,
1863: sa.start_from space_start_date,
1864: sa.end_to space_end_date
1865: FROM ahl_space_assignments sa,
1866: ahl_visits_vl vt,
1867: ahl_spaces_b sp
1868: WHERE sa.visit_id = vt.visit_id
1869: AND sp.space_id = sa.space_id
1870: AND vt.visit_id = c_visit_id;

Line 2136: FROM AHL_VISITS_VL

2132: /*
2133: CURSOR c_visit_sched_cur (c_visit_id IN NUMBER)
2134: IS
2135: SELECT 1
2136: FROM AHL_VISITS_VL
2137: WHERE VISIT_ID = c_visit_id
2138: AND (organization_id IS NULL
2139: OR department_id IS NULL
2140: OR start_date_time IS NULL );

Line 2147: FROM ahl_visits_vl

2143: CURSOR visit_det_cur IS
2144: SELECT organization_id,
2145: trunc(start_date_time),
2146: visit_name
2147: FROM ahl_visits_vl
2148: WHERE visit_id = p_x_schedule_visit_rec.visit_id;
2149:
2150: -- anraj: commented, issue number 144
2151: /*

Line 2926: FROM AHL_VISITS_VL WHERE VISIT_ID = l_visit_id;

2922: WHERE visit_id = l_visit_id;
2923: */
2924: -- Visit Name Mandatory for Update
2925: SELECT visit_name INTO l_visit_name
2926: FROM AHL_VISITS_VL WHERE VISIT_ID = l_visit_id;
2927:
2928: l_visit_tbl(i).VISIT_NUMBER := p_x_schedule_visit_rec.visit_number;
2929: l_visit_tbl(i).VISIT_NAME := l_visit_name;
2930: l_visit_tbl(i).organization_id := NULL;