APPS.AHL_PRD_VISITS_PVT dependencies on AHL_VISIT_TASKS_B

Line 57: FROM Ahl_Visit_Tasks_B

53: -- Define local Cursors
54: -- To find whether a visit exists
55: CURSOR c_visit (x_id IN NUMBER) IS
56: SELECT COUNT(*)
57: FROM Ahl_Visit_Tasks_B
58: WHERE VISIT_ID = x_id
59: AND NVL(STATUS_CODE,'X') <> 'DELETED';
60:
61: -- To find the total number of tasks for a visit

Line 64: FROM Ahl_Visit_Tasks_B

60:
61: -- To find the total number of tasks for a visit
62: CURSOR c_visit_task (x_id IN NUMBER) IS
63: SELECT COUNT(*)
64: FROM Ahl_Visit_Tasks_B
65: WHERE VISIT_ID = x_id
66: AND UNIT_EFFECTIVITY_ID IS NOT NULL
67: AND NVL(STATUS_CODE,'X') <> 'DELETED';
68:

Line 72: FROM ahl_unit_effectivities_vl T1, ahl_visit_tasks_b T2

68:
69: -- To find due date for a visit related with tasks
70: CURSOR c_due_date (x_id IN NUMBER) IS
71: SELECT MIN(T1.due_date)
72: FROM ahl_unit_effectivities_vl T1, ahl_visit_tasks_b T2
73: WHERE T1.unit_effectivity_id = T2.unit_effectivity_id
74: AND T1.due_date IS NOT NULL AND T2.visit_id = x_id;
75:
76: BEGIN