APPS.AHL_VWP_UNPLAN_TASKS_PVT dependencies on AHL_VISIT_TASKS_B

Line 584: FROM AHL_VISIT_TASKS_B AVTB, AHL_MR_HEADERS_APP_V AMHV

580:
581: -- To find any visit task exists for the retrieve Serial Number and MR_ID and other info
582: CURSOR c_MR_Visit (x_id IN NUMBER, x_mr_id IN NUMBER, x_serial_id in NUMBER) IS
583: SELECT AMHV.TITLE
584: FROM AHL_VISIT_TASKS_B AVTB, AHL_MR_HEADERS_APP_V AMHV
585: WHERE AVTB.MR_ID = AMHV.MR_HEADER_ID
586: AND AVTB.MR_Id in (select mr_header_id
587: from ahl_mr_headers_b
588: where title in

Line 761: UPDATE ahl_visit_tasks_b SET task_type_code = 'UNPLANNED'

757: X_return_status := Fnd_Api.G_RET_STS_ERROR;
758: RAISE Fnd_Api.G_EXC_ERROR;
759: END IF;
760:
761: UPDATE ahl_visit_tasks_b SET task_type_code = 'UNPLANNED'
762: WHERE visit_id = l_visit_id
763: AND visit_task_id IN
764: (
765: SELECT visit_task_id

Line 766: FROM ahl_visit_tasks_b

762: WHERE visit_id = l_visit_id
763: AND visit_task_id IN
764: (
765: SELECT visit_task_id
766: FROM ahl_visit_tasks_b
767: WHERE visit_id = l_visit_id
768: START WITH mr_id = l_mr_header_id AND originating_task_id IS NULL
769: /*B6452310 - sowsubra - after the implementation of same mr added muliple times, assume a planned
770: requirement is added followed by an unplanned requirement. Then here all the tasks should not be