APPS.AHL_LTP_SPACE_SCHEDULE_PVT dependencies on AHL_VISIT_TASKS_VL

Line 4604: FROM ahl_visit_tasks_vl

4600: /* Modified by mpothuku on 01/25/05 to include the status_code clause */
4601: CURSOR get_task_end_cur (c_visit_id IN NUMBER)
4602: IS
4603: SELECT max(end_date_time)
4604: FROM ahl_visit_tasks_vl
4605: WHERE visit_id = c_visit_id
4606: and status_code <> 'DELETED' ;
4607:
4608: --

Line 4784: FROM ahl_visit_tasks_vl

4780:
4781: CURSOR get_task_end_cur (c_visit_id IN NUMBER)
4782: IS
4783: SELECT max(end_date_time)
4784: FROM ahl_visit_tasks_vl
4785: WHERE visit_id = c_visit_id;
4786:
4787: --
4788: l_api_name CONSTANT VARCHAR2(30) := 'GET_VISIT_END_DATE';

Line 6144: FROM ahl_visit_tasks_vl

6140:
6141: CURSOR get_task_end_cur (c_visit_id IN NUMBER)
6142: IS
6143: SELECT max(end_date_time)
6144: FROM ahl_visit_tasks_vl
6145: WHERE visit_id = c_visit_id;
6146:
6147: l_start_date_time DATE;
6148: l_visit_end_time DATE;