APPS.AHL_LTP_SPACE_ASSIGN_PVT dependencies on AHL_VISITS_VL

Line 235: FROM AHL_VISITS_VL

231: IF (p_visit_id IS NOT NULL)
232: THEN
233: SELECT visit_id
234: INTO x_visit_id
235: FROM AHL_VISITS_VL
236: WHERE visit_id = p_visit_id;
237: ELSE
238: SELECT visit_id
239: INTO x_visit_id

Line 240: FROM AHL_VISITS_VL

236: WHERE visit_id = p_visit_id;
237: ELSE
238: SELECT visit_id
239: INTO x_visit_id
240: FROM AHL_VISITS_VL
241: WHERE visit_number = p_visit_number;
242: END IF;
243: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
244: EXCEPTION

Line 1473: ahl_visits_vl vt,

1469: vt.department_id,
1470: sp.organization_id sporg_id,
1471: sp.bom_department_id spdept_id
1472: FROM ahl_space_assignments sa,
1473: ahl_visits_vl vt,
1474: ahl_spaces_b sp
1475: WHERE sa.visit_id = vt.visit_id
1476: AND sp.space_id = sa.space_id
1477: AND vt.visit_id = c_visit_id;

Line 1726: FROM AHL_VISITS_VL

1722: /*
1723: CURSOR c_visit_sched_cur (c_visit_id IN NUMBER)
1724: IS
1725: SELECT 1
1726: FROM AHL_VISITS_VL
1727: WHERE VISIT_ID = c_visit_id
1728: AND (organization_id IS NULL
1729: OR department_id IS NULL
1730: OR start_date_time IS NULL );

Line 1737: FROM ahl_visits_vl

1733: CURSOR visit_det_cur IS
1734: SELECT organization_id,
1735: trunc(start_date_time),
1736: visit_name
1737: FROM ahl_visits_vl
1738: WHERE visit_id = p_x_schedule_visit_rec.visit_id;
1739:
1740: -- anraj: commented, issue number 144
1741: /*

Line 2516: FROM AHL_VISITS_VL WHERE VISIT_ID = l_visit_id;

2512: WHERE visit_id = l_visit_id;
2513: */
2514: -- Visit Name Mandatory for Update
2515: SELECT visit_name INTO l_visit_name
2516: FROM AHL_VISITS_VL WHERE VISIT_ID = l_visit_id;
2517:
2518: l_visit_tbl(i).VISIT_NUMBER := p_x_schedule_visit_rec.visit_number;
2519: l_visit_tbl(i).VISIT_NAME := l_visit_name;
2520: l_visit_tbl(i).organization_id := NULL;