APPS.AHL_PRD_WO_PUB dependencies on AHL_SEARCH_WORKORDERS_V

Line 1065: Select plan_id,collection_id from ahl_search_workorders_v

1061: l_workorder_id NUMBER;
1062: l_workorder_operation_id NUMBER;
1063:
1064: CURSOR get_wo_plan_csr(p_WorkorderId IN NUMBER)IS
1065: Select plan_id,collection_id from ahl_search_workorders_v
1066: WHERE workorder_id = p_WorkorderId;
1067:
1068: CURSOR get_op_plan_csr(p_WoOperationId IN NUMBER)IS
1069: Select plan_id,collection_id from ahl_workorder_operations_v