APPS.AHL_VWP_RULES_PVT dependencies on AHL_VISIT_TASKS_VL

Line 1507: FROM Ahl_Visit_Tasks_VL

1503: FROM dual;
1504:
1505: CURSOR c_id_exists_t (c_id IN NUMBER) IS
1506: SELECT 1
1507: FROM Ahl_Visit_Tasks_VL
1508: WHERE Visit_Task_id = c_id;
1509:
1510: -- Define local variables
1511: x_visit_task_id NUMBER;

Line 1637: SELECT VISIT_TASK_ID FROM AHL_VISIT_TASKS_VL

1633:
1634: -- To find out the tasks with tasktype code as planned for visits
1635: CURSOR c_route_task (x_route_id IN NUMBER, x_serial_id IN NUMBER,
1636: x_id IN NUMBER, x_type IN VARCHAR2) IS
1637: SELECT VISIT_TASK_ID FROM AHL_VISIT_TASKS_VL
1638: WHERE MR_ROUTE_ID = x_route_id AND INSTANCE_ID = x_serial_id
1639: AND VISIT_ID = x_id AND TASK_TYPE_CODE = x_type
1640: AND nvl(STATUS_CODE,'x') <> 'DELETED';
1641:

Line 2701: FROM Ahl_Visit_Tasks_VL

2697:
2698: -- To find any task which have originating id as deleted task id
2699: CURSOR c_origin (x_task_id IN NUMBER) IS
2700: SELECT Visit_Task_Id, Object_Version_Number
2701: FROM Ahl_Visit_Tasks_VL
2702: WHERE ORIGINATING_TASK_ID = x_task_id;
2703: c_origin_rec c_origin%ROWTYPE;
2704:
2705: -- To find any task which have parent id as deleted task id

Line 2708: FROM Ahl_Visit_Tasks_VL

2704:
2705: -- To find any task which have parent id as deleted task id
2706: CURSOR c_parent (x_task_id IN NUMBER) IS
2707: SELECT Visit_Task_Id, Object_Version_Number
2708: FROM Ahl_Visit_Tasks_VL
2709: WHERE COST_PARENT_ID = x_task_id;
2710: c_parent_rec c_parent%ROWTYPE;
2711:
2712: -- Post 11.5.10

Line 2717: FROM AHL_VISIT_TASKS_VL

2713: --RR
2714: -- For updating the Cost Parent Task
2715: CURSOR c_parent_id(x_task_id IN NUMBER) IS
2716: SELECT cost_parent_id
2717: FROM AHL_VISIT_TASKS_VL
2718: WHERE visit_task_id = x_task_id;
2719: l_parent_id NUMBER;
2720: -- Post 11.5.10
2721: --RR