APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 2879: FROM AHL_WORKORDER_TASKS_V WO, AHL_UNIT_CONFIG_HEADERS UCH

2875: --Note: This is root uc_header_id against the instance attached at task or visit level.
2876: CURSOR Get_Wo_Uc_Header_Id(c_workorder_id IN NUMBER)
2877: IS
2878: SELECT DISTINCT WO.uc_header_id, UCH.master_config_id, WO.visit_id
2879: FROM AHL_WORKORDER_TASKS_V WO, AHL_UNIT_CONFIG_HEADERS UCH
2880: WHERE WO.workorder_id = c_workorder_id AND
2881: UCH.unit_config_header_id = WO.uc_header_id;
2882:
2883: --Local variable declaration added for SB related changes.

Line 12360: AHL_UNIT_CONFIG_HEADERS UC, AHL_VISITS_B V

12356: AND vtsk.visit_task_id = c_visit_task_id;
12357:
12358: CURSOR get_uc_from_visit(c_visit_id NUMBER) IS
12359: Select UNIT_CONFIG_HEADER_ID from
12360: AHL_UNIT_CONFIG_HEADERS UC, AHL_VISITS_B V
12361: where V.ITEM_INSTANCE_ID = UC.CSI_ITEM_INSTANCE_ID
12362: AND V.ITEM_INSTANCE_ID = c_visit_id;
12363:
12364: l_unit_effectivity_id NUMBER := NULL;