APPS.AHL_VWP_RULES_PVT dependencies on AHL_VISIT_TASKS_VL

Line 1727: FROM Ahl_Visit_Tasks_VL

1723: FROM dual;
1724:
1725: CURSOR c_id_exists_t (c_id IN NUMBER) IS
1726: SELECT 1
1727: FROM Ahl_Visit_Tasks_VL
1728: WHERE Visit_Task_id = c_id;
1729:
1730: -- Define local variables
1731: x_visit_task_id NUMBER;

Line 1867: SELECT VISIT_TASK_ID FROM AHL_VISIT_TASKS_VL

1863: -- To find out the tasks with tasktype code as planned for visits
1864: --SKPATHAK : BUG 13997419 :: 26-APR-2012 :: Compare ue id of the tasks also to get the visit tasks between which rule needs to be created
1865: CURSOR c_route_task (x_route_id IN NUMBER, x_serial_id IN NUMBER,
1866: x_id IN NUMBER, x_type IN VARCHAR2, c_ue_id IN NUMBER) IS
1867: SELECT VISIT_TASK_ID FROM AHL_VISIT_TASKS_VL
1868: WHERE MR_ROUTE_ID = x_route_id AND INSTANCE_ID = x_serial_id
1869: AND VISIT_ID = x_id AND TASK_TYPE_CODE = x_type
1870: AND nvl(STATUS_CODE,'x') <> 'DELETED'
1871: AND UNIT_EFFECTIVITY_ID = c_ue_id;

Line 3020: FROM Ahl_Visit_Tasks_VL

3016:
3017: -- To find any task which have originating id as deleted task id
3018: CURSOR c_origin (x_task_id IN NUMBER) IS
3019: SELECT Visit_Task_Id, Object_Version_Number
3020: FROM Ahl_Visit_Tasks_VL
3021: WHERE ORIGINATING_TASK_ID = x_task_id;
3022: c_origin_rec c_origin%ROWTYPE;
3023:
3024: -- To find any task which have parent id as deleted task id

Line 3027: FROM Ahl_Visit_Tasks_VL

3023:
3024: -- To find any task which have parent id as deleted task id
3025: CURSOR c_parent (x_task_id IN NUMBER) IS
3026: SELECT Visit_Task_Id, Object_Version_Number
3027: FROM Ahl_Visit_Tasks_VL
3028: WHERE COST_PARENT_ID = x_task_id;
3029: c_parent_rec c_parent%ROWTYPE;
3030:
3031: -- Post 11.5.10

Line 3036: FROM AHL_VISIT_TASKS_VL

3032: --RR
3033: -- For updating the Cost Parent Task
3034: CURSOR c_parent_id(x_task_id IN NUMBER) IS
3035: SELECT cost_parent_id
3036: FROM AHL_VISIT_TASKS_VL
3037: WHERE visit_task_id = x_task_id;
3038: l_parent_id NUMBER;
3039: -- Post 11.5.10
3040: --RR

Line 3836: FROM AHL_VISIT_TASKS_VL ATSK, AHL_MR_HEADERS_B AMRH

3832:
3833: --cursor to fetch warranty template associated at MR
3834: CURSOR c_mr_template (c_task_id IN NUMBER) IS
3835: SELECT AMRH.WARRANTY_TEMPLATE_ID
3836: FROM AHL_VISIT_TASKS_VL ATSK, AHL_MR_HEADERS_B AMRH
3837: WHERE ATSK.MR_ID = AMRH.MR_HEADER_ID(+)
3838: AND ATSK.VISIT_TASK_ID = c_task_id;
3839:
3840: --cursor to fetch warranty template associated at route

Line 3843: FROM AHL_VISIT_TASKS_VL ATSK,

3839:
3840: --cursor to fetch warranty template associated at route
3841: CURSOR c_route_template (c_task_id IN NUMBER) IS
3842: SELECT ARV.WARRANTY_TEMPLATE_ID
3843: FROM AHL_VISIT_TASKS_VL ATSK,
3844: AHL_MR_ROUTES_V AMRR,
3845: AHL_ROUTES_B ARV
3846: WHERE ATSK.MR_ROUTE_ID = AMRR.MR_ROUTE_ID(+)
3847: AND AMRR.ROUTE_ID = ARV.ROUTE_ID (+)