APPS.AHL_LTP_SPACE_SCHEDULE_PVT dependencies on AHL_VISIT_TASKS_B

Line 4940: FROM Ahl_Visit_Tasks_B

4936:
4937: -- To find whether a visit exists
4938: CURSOR c_visit (x_id IN NUMBER) IS
4939: SELECT COUNT(*)
4940: FROM Ahl_Visit_Tasks_B
4941: WHERE VISIT_ID = x_id;
4942:
4943: -- To find the total number of tasks for a visit
4944: CURSOR c_visit_task (x_id IN NUMBER) IS

Line 4946: FROM Ahl_Visit_Tasks_B

4942:
4943: -- To find the total number of tasks for a visit
4944: CURSOR c_visit_task (x_id IN NUMBER) IS
4945: SELECT COUNT(*)
4946: FROM Ahl_Visit_Tasks_B
4947: WHERE VISIT_ID = x_id AND UNIT_EFFECTIVITY_ID IS NOT NULL;
4948:
4949: -- To find due date for a visit related with tasks
4950: CURSOR c_due_date (x_id IN NUMBER) IS

Line 4952: FROM ahl_unit_effectivities_app_v T1, ahl_visit_tasks_b T2

4948:
4949: -- To find due date for a visit related with tasks
4950: CURSOR c_due_date (x_id IN NUMBER) IS
4951: SELECT MAX(T1.due_date)
4952: FROM ahl_unit_effectivities_app_v T1, ahl_visit_tasks_b T2
4953: WHERE T1.unit_effectivity_id = T2.unit_effectivity_id AND T2.visit_id = x_id;
4954:
4955: BEGIN
4956: -- Standard Start of API savepoint

Line 5268: AHL_VISIT_TASKS_B B

5264: trunc(VST.CLOSE_DATE_TIME) close_date_time,
5265: (
5266: SELECT MAX(DUE_DATE)
5267: FROM AHL_UNIT_EFFECTIVITIES_B A,
5268: AHL_VISIT_TASKS_B B
5269: WHERE A.UNIT_EFFECTIVITY_ID = B.UNIT_EFFECTIVITY_ID
5270: AND B.VISIT_ID = VST.VISIT_ID
5271: GROUP BY VISIT_ID
5272: ) due_by

Line 5305: AHL_VISIT_TASKS_B B

5301: trunc(VST.CLOSE_DATE_TIME) close_date_time,
5302: (
5303: SELECT MAX(DUE_DATE)
5304: FROM AHL_UNIT_EFFECTIVITIES_B A,
5305: AHL_VISIT_TASKS_B B
5306: WHERE A.UNIT_EFFECTIVITY_ID = B.UNIT_EFFECTIVITY_ID
5307: AND B.VISIT_ID = VST.VISIT_ID
5308: GROUP BY VISIT_ID
5309: ) due_by