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 709: FROM ahl_visit_tasks_b

705: WHERE visit_id = l_visit_id
706: AND visit_task_id IN
707: (
708: SELECT visit_task_id
709: FROM ahl_visit_tasks_b
710: WHERE visit_id = l_visit_id
711: START WITH mr_id = l_mr_header_id AND originating_task_id IS NULL
712: AND UNIT_EFFECTIVITY_ID = p_x_task_Rec.unit_effectivity_id
713: CONNECT BY cost_parent_id = PRIOR visit_task_id

Line 720: UPDATE ahl_visit_tasks_b SET task_type_code = 'UNPLANNED'

716:
717: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
718: fnd_log.string(fnd_log.level_statement, l_full_name, 'Number of ahl_schedule_materials records updated: ' || SQL%ROWCOUNT);
719: END IF;
720: UPDATE ahl_visit_tasks_b SET task_type_code = 'UNPLANNED'
721: WHERE visit_id = l_visit_id
722: AND visit_task_id IN
723: (
724: SELECT visit_task_id

Line 725: FROM ahl_visit_tasks_b

721: WHERE visit_id = l_visit_id
722: AND visit_task_id IN
723: (
724: SELECT visit_task_id
725: FROM ahl_visit_tasks_b
726: WHERE visit_id = l_visit_id
727: START WITH mr_id = l_mr_header_id AND originating_task_id IS NULL
728: /*B6452310 - sowsubra - after the implementation of same mr added muliple times, assume a planned
729: requirement is added followed by an unplanned requirement. Then here all the tasks should not be