[Home] [Help]
11151: -- To get all the tasks for the given UE
11152: CURSOR c_task (x_visit_id IN NUMBER, x_unit_effectivity_id IN NUMBER) IS
11153: -- SKPATHAK :: Bug 8340436 :: 23-MAR-2009
11154: -- Fetch distinct rows to avoid duplicates
11155: -- Select individual cols instead of *
11156: --SELECT * FROM AHL_VISIT_TASKS_VL
11157: SELECT distinct visit_task_id, originating_task_id, visit_id, unit_effectivity_id,
11158: status_code, service_request_id, project_task_id, visit_task_number,
11159: visit_task_name, description, object_version_number, task_type_code,
11816: -- To get all the tasks for the given UE
11817: CURSOR c_task (x_visit_id IN NUMBER, x_unit_effectivity_id IN NUMBER) IS
11818: -- SKPATHAK :: Bug 8340436 :: 23-MAR-2009
11819: -- Fetch distinct rows to avoid duplicates
11820: -- Select individual cols instead of *
11821: --SELECT * FROM AHL_VISIT_TASKS_VL
11822: SELECT distinct visit_task_id, originating_task_id, visit_id, unit_effectivity_id,
11823: status_code, service_request_id, project_task_id, visit_task_number,
11824: visit_task_name, description, object_version_number, start_date_time,
14678: l_has_pre_in_planning VARCHAR2(1);
14679:
14680: -- PRAKKUM :: VWPE: ER:12673125 :: 23-JUN-2011 :: Upgrade Changes - To find visit is old or new
14681: CURSOR c_is_old_visit(p_visit_id IN NUMBER) IS
14682: select AHL_VWP_VISITS_PVT.Is_Old_Visit(p_visit_id) IS_OLD_VISIT FROM DUAL;
14683:
14684: l_is_old_visit_dets c_is_old_visit%RowType;
14685:
14686: l_max_schedule_start_date DATE; --BUG 13373947 :: PRAKKUM :: 10/02/2012